-
15. Re: Re: jboss and teiid Federated Plans
thanks very much , i can start the JBOSS EAP successfully . but after i output the query plan,it's still the same sitiation :
ProjectNode
+ Output Columns:cnt (integer)
+ Statistics:
0: Node Output Rows: 2
1: Node Process Time: 0
2: Node Cumulative Process Time: 21714
3: Node Cumulative Next Batch Process Time: 395
4: Node Next Batch Calls: 781
5: Node Blocks: 780
+ Cost Estimates:Estimated Node Cardinality: -1.0
+ Child 0:
GroupingNode
+ Output Columns:gcol0 (integer)
+ Statistics:
0: Node Output Rows: 2
1: Node Process Time: 168
2: Node Cumulative Process Time: 21714
3: Node Cumulative Next Batch Process Time: 394
4: Node Next Batch Calls: 781
5: Node Blocks: 780
+ Cost Estimates:Estimated Node Cardinality: -1.0
+ Child 0:
UnionAllNode
+ Output Columns:start_time (timestamp)
+ Statistics:
0: Node Output Rows: 411598
1: Node Process Time: 0
2: Node Cumulative Process Time: 21546
3: Node Cumulative Next Batch Process Time: 48
4: Node Next Batch Calls: 1182
5: Node Blocks: 980
+ Child 0:
AccessNode
+ Output Columns:start_time (timestamp)
+ Statistics:
0: Node Output Rows: 205799
1: Node Process Time: 21546
2: Node Cumulative Process Time: 21546
3: Node Cumulative Next Batch Process Time: 25
4: Node Next Batch Calls: 1182
5: Node Blocks: 1081
+ Query:SELECT g_0.start_time FROM mysql5.zhangwf.GPRS_USER_SERVICE_BDR030427 AS g_0 WHERE g_0.roam_city = 20
+ Model Name:mysql5
+ Model Name:mysql5
+ Child 1:
AccessNode
+ Output Columns:start_time (timestamp)
+ Statistics:
0: Node Output Rows: 205799
1: Node Process Time: 6493
2: Node Cumulative Process Time: 6493
3: Node Cumulative Next Batch Process Time: 21
4: Node Next Batch Calls: 581
5: Node Blocks: 480
+ Query:SELECT g_0.start_time FROM mysql5.zhangwf.GPRS_USER_SERVICE_BDR030427 AS g_0 WHERE g_0.roam_city = 20
+ Model Name:mysql5
+ Model Name:mysql5
+ Grouping Columns:hour(start_time)
+ Sort Mode:false
+ Select Columns:anon_grp0.gcol0 AS cnt
i don't want it pushdown ,just exeute the original sql :select hour(start_time) cnt From GPRS_USER_SERVICE_BDR030427 where roam_city=20 group by hour(start_time) order by hour(start_time) .
if it can be set ? i haven't find the relevant configuration or parameter .
by the way, i try to build teiid 8.8 ,but it fails , i don't know if my method is wrong or it's missing something : (i install the maven version of apache-maven-3.2.1-bin.tar.gz)
$ unzip teiid-8.8.0.Alpha2-src.zip
$ cd teiid
$ mvn clean install -P release -s settings.xml
[INFO] Scanning for projects...
[ERROR] The build could not read 1 project -> [Help 1]
[ERROR]
[ERROR] The project org.jboss.teiid:teiid-parent:8.8.0.Alpha2 (/zhangwf/software/teiid/pom.xml) has 1 error
[ERROR] Non-resolvable parent POM: Could not transfer artifact org.jboss.integration-platform:jboss-integration-platform-parent:pom:6.0.0.CR8 from/to jboss-eap-alpha (http://maven.repository.redhat.com/techpreview/eap6/6.1.0.Alpha1/maven-repository/): maven.repository.redhat.com: Temporary failure in name resolution and 'parent.relativePath' points at wrong local POM @ line 3, column 10: Unknown host maven.repository.redhat.com: Temporary failure in name resolution -> [Help 2]
[ERROR]
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR]
[ERROR] For more information about the errors and possible solutions, please read the following articles:
[ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/ProjectBuildingException
[ERROR] [Help 2] http://cwiki.apache.org/confluence/display/MAVEN/UnresolvableModelException
thanks a lot.
-
16. Re: jboss and teiid Federated Plans
> ,just exeute the original sql
The next issue you are hitting is that your VDB is configured to use the mysql translator rather than the mysql5 translator. This is somewhat of a legacy pattern that a distinct is made as newer translators attempt to span more versions. In any case the mysql translator is not marked as supporting inline views nor functions as a grouping expression, so the planner will not push the aggregation over a function down.
> by the way, i try to build teiid 8.8 ,but it fails , i don't know if my method is wrong or it's missing something
What you've done is correct. I'm not sure what your are seeing there though as the CR8 artifact is in the JBoss public repository. Also locally my build works as expected using the settings.xml. What maven version are you on?
-
17. Re: jboss and teiid Federated Plans
hello,
> ,just exeute the original sql
you mean the fix is only for mysql translator instead of all translators? i mistake that the fix is for all translator and update is for query engine instead of translator.
> by the way, i try to build teiid 8.8 ,but it fails , i don't know if my method is wrong or it's missing something
i tried again , it start successfully. but i takes too much time , and after that it failed . i didn't find "teiid/build/target" directory.
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 44:18 min
[INFO] Finished at: 2014-06-04T18:27:29+08:00
[INFO] Final Memory: 232M/1521M
[INFO] ------------------------------------------------------------------------
[ERROR] Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:2.12.3:test (default-test) on project test-integration-common: There are test failures.
[ERROR]
[ERROR] Please refer to /hadoop/zhangwf/teiid/test-integration/common/target/surefire-reports for the individual test results.
[ERROR] -> [Help 1]
[ERROR]
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR]
[ERROR] For more information about the errors and possible solutions, please read the following articles:
[ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoFailureException
[ERROR]
[ERROR] After correcting the problems, you can resume the build with the command
[ERROR] mvn <goals> -rf :test-integration-common
what's the successful sign of complete build ?
thanks a lot.
-
18. Re: jboss and teiid Federated Plans
> you mean the fix is only for mysql translator instead of all translators? i mistake that the fix is for all translator and update is for query engine instead of translator.
You needed the general fix to the engine (TEIID-2968), but you must now also change your vdb to use the mysql5 translator rather than the mysql translator. The mysql translator represents older mysql versions which do not support the ability to perform aggregation on a function. That is instead of:
<source name="mysql82" translator-name="mysql" connection-jndi-name="java:mysql82DS"/>
You should have
<source name="mysql82" translator-name="mysql5" connection-jndi-name="java:mysql82DS"/>
> what's the successful sign of complete build ?
Maven will complete and indicate build successful. Did your build have an issue with a particular test or just that the entire process took too long?
-
19. Re: Re: jboss and teiid Federated Plans
> what's the successful sign of complete build ?
Maven will complete and indicate build successful. Did your build have an issue with a particular test or just that the entire process took too long?
it seems that i failed . the entire process takes too long. and it fails when bulid test project Partially. and i attempt to try again ,but it also fails:
[INFO] ------------------------------------------------------------------------
[INFO] Reactor Summary:
[INFO]
[INFO] Teiid ............................................. SUCCESS [ 1.651 s]
[INFO] Common Core ....................................... SUCCESS [ 9.578 s]
[INFO] Client ............................................ SUCCESS [ 10.380 s]
[INFO] admin ............................................. SUCCESS [ 3.858 s]
[INFO] Teiid API ......................................... SUCCESS [ 3.714 s]
[INFO] Engine ............................................ SUCCESS [01:07 min]
[INFO] Metadata .......................................... SUCCESS [ 3.606 s]
[INFO] Connectors ........................................ SUCCESS [ 0.109 s]
[INFO] JDBC Translator ................................... SUCCESS [ 13.059 s]
[INFO] Gogole API ........................................ SUCCESS [ 1.245 s]
[INFO] Google APIs Translator ............................ SUCCESS [ 4.150 s]
[INFO] LDAP Translator ................................... SUCCESS [ 3.344 s]
[INFO] Loopback Translator ............................... SUCCESS [ 2.998 s]
[INFO] File Translator ................................... SUCCESS [ 1.448 s]
[INFO] Salesforce API .................................... SUCCESS [ 1.285 s]
[INFO] Salesforce Translator ............................. SUCCESS [ 4.246 s]
[INFO] File Resource Adapter ............................. SUCCESS [ 1.737 s]
[INFO] Google API Resource Adapter ....................... SUCCESS [ 0.423 s]
[INFO] Salesforce Resource Adapter ....................... SUCCESS [ 1.649 s]
[INFO] LDAP Resource Adapter ............................. SUCCESS [ 1.271 s]
[INFO] Web Service Adapter ............................... SUCCESS [ 1.967 s]
[INFO] Sandbox ........................................... SUCCESS [ 0.053 s]
[INFO] Yahoo Translator .................................. SUCCESS [ 2.696 s]
[INFO] Web service Translator ............................ SUCCESS [ 3.589 s]
[INFO] OLAP Translator ................................... SUCCESS [ 3.096 s]
[INFO] Hive Translator ................................... SUCCESS [ 3.225 s]
[INFO] JPA2 Translator ................................... SUCCESS [ 3.390 s]
[INFO] Object Translator ................................. SUCCESS [ 6.317 s]
[INFO] Infinispan Resource Adapter ....................... SUCCESS [ 9.492 s]
[INFO] Odata Translator .................................. SUCCESS [ 5.997 s]
[INFO] MongoDB API ....................................... SUCCESS [ 0.207 s]
[INFO] MongoDB Resource Adapter .......................... SUCCESS [ 0.388 s]
[INFO] MongoDB Translator ................................ SUCCESS [ 4.975 s]
[INFO] Cassandra CQL translator .......................... SUCCESS [ 3.356 s]
[INFO] Cassandra Resource Adapter ........................ SUCCESS [ 1.685 s]
[INFO] Infinispan Connector 6 ............................ SUCCESS [ 5.368 s]
[INFO] SimpleDB API ...................................... SUCCESS [ 0.157 s]
[INFO] SimpleDB Connector ................................ SUCCESS [ 1.877 s]
[INFO] Amazon SimpleDB Translator ........................ SUCCESS [ 3.654 s]
[INFO] Accumulo translator ............................... SUCCESS [ 4.525 s]
[INFO] Accumulo Resource Adapter ......................... SUCCESS [ 0.606 s]
[INFO] Apache SOLR Translator ............................ SUCCESS [ 3.203 s]
[INFO] Apache SOLR Resource Adapter ...................... SUCCESS [ 0.441 s]
[INFO] Excel Translator .................................. SUCCESS [ 5.331 s]
[INFO] Runtime Engine .................................... FAILURE [03:48 min]
[INFO] Adminshell ........................................ SKIPPED
[INFO] Hibernate Dialect ................................. SKIPPED
[INFO] teiid-jboss-integration ........................... SKIPPED
[INFO] Integration Tests ................................. SKIPPED
[INFO] Common Integration Tests .......................... SKIPPED
[INFO] DB Dependent Integration Tests .................... SKIPPED
[INFO] Performance Integration Tests ..................... SKIPPED
[INFO] Client JDK15 ...................................... SKIPPED
[INFO] teiid-odata ....................................... SKIPPED
[INFO] Build ............................................. SKIPPED
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 07:26 min
[INFO] Finished at: 2014-06-05T10:23:48+08:00
[INFO] Final Memory: 213M/1588M
[INFO] ------------------------------------------------------------------------
[ERROR] Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:2.12.3:test (default-test) on project teiid-runtime: There are test failures.
[ERROR]
[ERROR] Please refer to /hadoop/zhangwf/teiid/runtime/target/surefire-reports for the individual test results.
[ERROR] -> [Help 1]
[ERROR]
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR]
[ERROR] For more information about the errors and possible solutions, please read the following articles:
[ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoFailureException
[ERROR]
[ERROR] After correcting the problems, you can resume the build with the command
[ERROR] mvn <goals> -rf :teiid-runtime
> you mean the fix is only for mysql translator instead of all translators? i mistake that the fix is for all translator and update is for query engine instead of translator.
i update the translator to mysql5 , then success. but when i replace sybase translator , it still occurs weiid problems:
15:00:33,014 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-1) TEIID40118 VDB MyTest.1 added to the repository - is reloading true
15:00:33,016 INFO [org.teiid.RUNTIME] (MSC service thread 1-1) TEIID50029 VDB MyTest.1 model "sybiq" metadata is currently being loaded. Start Time: 6/5/14 3:00 PM
15:00:33,017 INFO [org.jboss.web] (ServerService Thread Pool -- 52) JBAS018210: Register web context: /odata
15:00:33,299 WARN [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 1) TEIID31152 More the one constraint with the name sybiq.dmpiq1.SYS.ISYSFKEY.ISYSIDX001.
15:00:33,302 WARN [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 1) TEIID31152 More the one constraint with the name sybiq.dmpiq1.SYS.ISYSIQIDX.ISYSIDX001.
15:00:33,303 WARN [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 1) TEIID31152 More the one constraint with the name sybiq.dmpiq1.SYS.ISYSIQJOINIXCOLUMN.ISYSTABCOL001.
15:00:33,304 WARN [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 1) TEIID31152 More the one constraint with the name sybiq.dmpiq1.SYS.ISYSTABCOL.ISYSTABCOL_unique.
15:00:33,306 INFO [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID40073 The metadata for the VDB MyTest.1 is loaded, however it is not valid. Check models for errors. Correct the metadata and re-deploy.
15:00:33,306 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (teiid-async-threads - 1) TEIID40003 VDB MyTest.1 is set to FAILED
15:00:33,308 INFO [org.hibernate.validator.internal.util.Version] (ServerService Thread Pool -- 52) HV000001: Hibernate Validator 4.3.1.Final
15:00:33,525 INFO [org.jboss.resteasy.spi.ResteasyDeployment] (ServerService Thread Pool -- 52) Deploying javax.ws.rs.core.Application: class org.teiid.odata.TeiidODataApplication
15:00:34,020 INFO [org.jboss.as.server] (ServerService Thread Pool -- 27) JBAS018559: Deployed "MyTest-vdb.xml" (runtime-name : "MyTest-vdb.xml")
15:00:34,021 INFO [org.jboss.as.server] (ServerService Thread Pool -- 44) JBAS018559: Deployed "teiid-odata-8.8.0.Alpha2.war" (runtime-name : "teiid-odata-8.8.0.Alpha2.war")
15:00:34,083 INFO [org.jboss.as] (Controller Boot Thread) JBAS015961: Http management interface listening on http://192.168.7.220:9990/management
15:00:34,084 INFO [org.jboss.as] (Controller Boot Thread) JBAS015951: Admin console listening on http://192.168.7.220:9990
15:00:34,084 INFO [org.jboss.as] (Controller Boot Thread) JBAS015874: JBoss EAP 6.1.0.Alpha1 (AS 7.2.0.Alpha1-redhat-4) started in 8404ms - Started 328 of 407 services (76 services are passive or on-demand).
follow is my vdb.xml
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<vdb name="MyTest" version="1">
<description>My Test sybiq VDB</description>
<property name="UseConnectorMetadata" value="cached" />
<model visible="true" type="PHYSICAL" name="sybiq">
<property name="importer.useFullSchemaName" value="true"/>
<property name="supports-multi-source-bindings" value="true"/>
<source name="sybiq211" translator-name="sybase" connection-jndi-name="java:sybiq211DS"/>
<source name="sybiq210" translator-name="sybase" connection-jndi-name="java:sybiq210DS"/>
</model>
</vdb>
and standalone-teiid.xml:
<datasources>
<datasource jndi-name="java:/sybiq210DS" pool-name="sybiq210DS" enabled="true" use-java-context="true" use-ccm="false">
<connection-url>jdbc:sybase:Tds:192.168.7.210:2640/dmpiq1</connection-url>
<driver>sybase</driver>
<security>
<user-name>zcss7db</user-name>
<password>zcss7db</password>
</security>
<validation>
<check-valid-connection-sql>select name from sysobjects where type='U' order by name</check-valid-connection-sql>
<validate-on-match>false</validate-on-match>
<background-validation>false</background-validation>
<background-validation-millis>200</background-validation-millis>
</validation>
</datasource>
<datasource jndi-name="java:/sybiq211DS" pool-name="sybiq211DS" enabled="true" use-java-context="true" use-ccm="false">
<connection-url>jdbc:sybase:Tds:192.168.7.211:2640/dmpiq2</connection-url>
<driver>sybase</driver>
<security>
<user-name>zcss7db</user-name>
<password>zcss7db</password>
</security>
<validation>
<check-valid-connection-sql>select name from sysobjects where type='U' order by name</check-valid-connection-sql>
<validate-on-match>false</validate-on-match>
<background-validation>false</background-validation>
<background-validation-millis>200</background-validation-millis>
</validation>
</datasource>
-
20. Re: Re: jboss and teiid Federated Plans
> [INFO] Runtime Engine .................................... FAILURE [03:48 min]
We don't expect that you'll see any failing tests. If you can tell us which test is failing we'll see if there is a localization or other issue that needs addressed.
> i update the translator to mysql5 , then success. but when i replace sybase translator , it still occurs weiid problems:
We used to be more lax on this, but with TEIID-2922 for Teiid Designer we added a validation to make sure that only unique constraint names are being used. There may be something odd with how SQL Anywhere is reporting the system metadata. If you don't need the system tables as part of your vdb, then you should exclude them using an import property, such as schemaPattern, tableNamePattern, or excludeTables - see JDBC Translator - Teiid 8.8 (draft) - Project Documentation Editor under importer properties.
> check-valid-connection-sql>select name from sysobjects where type='U' order by name</check-valid-connection-sql>
You probably want a less expensive query for this purpose.
-
21. Re: Re: Re: jboss and teiid Federated Plans
i'm so sorry to bother you again , after i modify the pom.xml in teiid , i build it successfully. follow is the updating section:
<id>release</id>
<properties>
<maven.javadoc.skip>true</maven.javadoc.skip>
<skipTests>true</skipTests>
</properties>
i want to know if there are some potencial problems? and is it ok to use?
thanks.
-
22. Re: Re: Re: jboss and teiid Federated Plans
> i want to know if there are some potencial problems? and is it ok to use?
You can of course skip the tests if you want to. The only potential problem is that whatever latent issue is happening for your unit test run will go unresolved.
-
23. Re: Re: Re: Re: jboss and teiid Federated Plans
hello , i download the source code of teiid-8.2.0.Final-src.zip . and i try to build that for several times ,but it failed .
unzip teiid-8.2.0.Final-src.zip
cd teiid
mvn clean install -P release
[INFO] Building Engine 8.2.0.Final
[INFO] ------------------------------------------------------------------------
[WARNING] The POM for net.sourceforge.saxon:saxonhe:jar:9.2.1.5 is missing, no dependency information available
[WARNING] The POM for nux:nux:jar:1.6 is missing, no dependency information available
[WARNING] The POM for xom:xom:jar:1.2 is missing, no dependency information available
[INFO] ------------------------------------------------------------------------
[INFO] Reactor Summary:
[INFO]
[INFO] Teiid ............................................. SUCCESS [ 1.257 s]
[INFO] Common Core ....................................... SUCCESS [ 9.545 s]
[INFO] Client ............................................ SUCCESS [ 11.642 s]
[INFO] admin ............................................. SUCCESS [ 4.127 s]
[INFO] Teiid API ......................................... SUCCESS [ 5.551 s]
[INFO] Engine ............................................ FAILURE [ 0.069 s]
[INFO] Metadata .......................................... SKIPPED
[INFO] Connectors ........................................ SKIPPED
[INFO] JDBC Translator ................................... SKIPPED
[INFO] Gogole API ........................................ SKIPPED
[INFO] Google APIs Translator ............................ SKIPPED
[INFO] LDAP Translator ................................... SKIPPED
[INFO] Loopback Translator ............................... SKIPPED
[INFO] File Translator ................................... SKIPPED
[INFO] Salesforce API .................................... SKIPPED
[INFO] Salesforce Translator ............................. SKIPPED
[INFO] File Connector .................................... SKIPPED
[INFO] Google API Connector .............................. SKIPPED
[INFO] Salesforce Connector .............................. SKIPPED
[INFO] LDAP Connector .................................... SKIPPED
[INFO] Web Service Connector ............................. SKIPPED
[INFO] Sandbox ........................................... SKIPPED
[INFO] Yahoo Translator .................................. SKIPPED
[INFO] Web service Translator ............................ SKIPPED
[INFO] OLAP Translator ................................... SKIPPED
[INFO] Hive Translator ................................... SKIPPED
[INFO] JPA2 Translator ................................... SKIPPED
[INFO] Object Translator ................................. SKIPPED
[INFO] Infinispan Connector .............................. SKIPPED
[INFO] Runtime Engine .................................... SKIPPED
[INFO] Adminshell ........................................ SKIPPED
[INFO] Hibernate Dialect ................................. SKIPPED
[INFO] teiid-jboss-integration ........................... SKIPPED
[INFO] Integration Tests ................................. SKIPPED
[INFO] Common Integration Tests .......................... SKIPPED
[INFO] DB Dependent Integration Tests .................... SKIPPED
[INFO] Performance Integration Tests ..................... SKIPPED
[INFO] Client JDK15 ...................................... SKIPPED
[INFO] Build ............................................. SKIPPED
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 33.591 s
[INFO] Finished at: 2014-06-09T16:15:30+08:00
[INFO] Final Memory: 63M/679M
[INFO] ------------------------------------------------------------------------
[ERROR] Failed to execute goal on project teiid-engine: Could not resolve dependencies for project org.jboss.teiid:teiid-engine:jar:8.2.0.Final: The following artifacts could not be resolved: net.sourceforge.saxon:saxonhe:jar:9.2.1.5, nux:nux:jar:1.6, xom:xom:jar:1.2: Failure to find net.sourceforge.saxon:saxonhe:jar:9.2.1.5 in http://repo.maven.apache.org/maven2 was cached in the local repository, resolution will not be reattempted until the update interval of central has elapsed or updates are forced -> [Help 1]
[ERROR]
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR]
[ERROR] For more information about the errors and possible solutions, please read the following articles:
[ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/DependencyResolutionException
[ERROR]
[ERROR] After correcting the problems, you can resume the build with the command
[ERROR] mvn <goals> -rf :teiid-engine
i seems that it can't download some relevant dependency . but in the same server i can bulid teiid-alpha1 and teiid-alpha2 successfully . i don't know what's wrong with that? i wonder that if i can download that alone and put it in maven directory.
and i tried to excute the following command:
mvn clean install -P release -s settings.xml
it also have problems:
[INFO] Building Gogole API 8.2.0.Final
[INFO] ------------------------------------------------------------------------
[WARNING] The POM for org.jboss.teiid.connectors.google:gdata-spreadsheet:jar:3.0 is missing, no dependency information available
[WARNING] The POM for org.jboss.teiid.connectors.google:gdata-core:jar:1.0 is missing, no dependency information available
[INFO] ------------------------------------------------------------------------
[INFO] Reactor Summary:
[INFO]
[INFO] Teiid ............................................. SUCCESS [ 1.256 s]
[INFO] Common Core ....................................... SUCCESS [ 7.739 s]
[INFO] Client ............................................ SUCCESS [ 6.622 s]
[INFO] admin ............................................. SUCCESS [ 3.385 s]
[INFO] Teiid API ......................................... SUCCESS [ 4.435 s]
[INFO] Engine ............................................ SUCCESS [ 25.011 s]
[INFO] Metadata .......................................... SUCCESS [ 3.537 s]
[INFO] Connectors ........................................ SUCCESS [ 0.097 s]
[INFO] JDBC Translator ................................... SUCCESS [ 6.256 s]
[INFO] Gogole API ........................................ FAILURE [ 0.066 s]
[INFO] Google APIs Translator ............................ SKIPPED
[INFO] LDAP Translator ................................... SKIPPED
[INFO] Loopback Translator ............................... SKIPPED
[INFO] File Translator ................................... SKIPPED
[INFO] Salesforce API .................................... SKIPPED
[INFO] Salesforce Translator ............................. SKIPPED
[INFO] File Connector .................................... SKIPPED
[INFO] Google API Connector .............................. SKIPPED
[INFO] Salesforce Connector .............................. SKIPPED
[INFO] LDAP Connector .................................... SKIPPED
[INFO] Web Service Connector ............................. SKIPPED
[INFO] Sandbox ........................................... SKIPPED
[INFO] Yahoo Translator .................................. SKIPPED
[INFO] Web service Translator ............................ SKIPPED
[INFO] OLAP Translator ................................... SKIPPED
[INFO] Hive Translator ................................... SKIPPED
[INFO] JPA2 Translator ................................... SKIPPED
[INFO] Object Translator ................................. SKIPPED
[INFO] Infinispan Connector .............................. SKIPPED
[INFO] Runtime Engine .................................... SKIPPED
[INFO] Adminshell ........................................ SKIPPED
[INFO] Hibernate Dialect ................................. SKIPPED
[INFO] teiid-jboss-integration ........................... SKIPPED
[INFO] Integration Tests ................................. SKIPPED
[INFO] Common Integration Tests .......................... SKIPPED
[INFO] DB Dependent Integration Tests .................... SKIPPED
[INFO] Performance Integration Tests ..................... SKIPPED
[INFO] Client JDK15 ...................................... SKIPPED
[INFO] Build ............................................. SKIPPED
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 59.804 s
[INFO] Finished at: 2014-06-09T17:31:49+08:00
[INFO] Final Memory: 100M/1467M
[INFO] ------------------------------------------------------------------------
[ERROR] Failed to execute goal on project google-api: Could not resolve dependencies for project org.jboss.teiid.connectors:google-api:jar:8.2.0.Final: The following artifacts could not be resolved: org.jboss.teiid.connectors.google:gdata-spreadsheet:jar:3.0, org.jboss.teiid.connectors.google:gdata-core:jar:1.0: Failure to find org.jboss.teiid.connectors.google:gdata-spreadsheet:jar:3.0 in http://repository.jboss.org/nexus/content/groups/public/ was cached in the local repository, resolution will not be reattempted until the update interval of jboss-public-repository-group has elapsed or updates are forced -> [Help 1]
[ERROR]
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR]
[ERROR] For more information about the errors and possible solutions, please read the following articles:
[ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/DependencyResolutionException
[ERROR]
[ERROR] After correcting the problems, you can resume the build with the command
[ERROR] mvn <goals> -rf :google-api
so how can i resolve these dependency problems? thanks .