You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lens.apache.org by "Arshad Matin (JIRA)" <ji...@apache.org> on 2014/11/14 07:36:33 UTC
[jira] [Commented] (LENS-13) lens example queries failing on jdbc
[ https://issues.apache.org/jira/browse/LENS-13?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14211919#comment-14211919 ]
Arshad Matin commented on LENS-13:
----------------------------------
{noformat}
./run-examples.sh sample-metastore -db dbcheck9
javax.xml.bind.MarshalException: Invalid set of fields set for XMLGregorianCalendar type dateTime. Seconds not set. Minutes not set. Hour not set.
javax.xml.bind.MarshalException: Invalid set of fields set for XMLGregorianCalendar type dateTime. Seconds not set. Minutes not set. Hour not set.
javax.xml.bind.MarshalException: Invalid set of fields set for XMLGregorianCalendar type dateTime. Seconds not set. Minutes not set. Hour not set.
javax.xml.bind.MarshalException: Invalid set of fields set for XMLGregorianCalendar type dateTime. Seconds not set. Minutes not set. Hour not set.
javax.xml.bind.MarshalException: Invalid set of fields set for XMLGregorianCalendar type dateTime. Seconds not set. Minutes not set. Hour not set.
javax.xml.bind.MarshalException: Invalid set of fields set for XMLGregorianCalendar type dateTime. Seconds not set. Minutes not set. Hour not set.
javax.xml.bind.MarshalException: Invalid set of fields set for XMLGregorianCalendar type dateTime. Seconds not set. Minutes not set. Hour not set.
Created sample metastore!
Database:dbcheck9
Storages:[cluster1, local, mydb]
Cubes:[sample_cube]
Dimensions:[sample_db_dim, sample_dim, sample_dim2]
Fact tables:[fact1, fact2, rawfact]
Dimension tables:[dim_table, dim_table2, dim_table3, dim_table4]
{noformat}
{noformat}
./run-examples.sh populate-metastore -db dbcheck9
Added partition from:dim1-local-part.xml
Added partition from:dim2-local-part.xml
Added partition from:dim4-local-part.xml
Created DB storages for dim_table3 and dim_table4
Added partition from:fact1-local-part1.xml
Added partition from:fact1-local-part2.xml
Added partition from:fact1-local-part3.xml
Added partition from:fact2-local-part1.xml
Added partition from:fact2-local-part2.xml
Added partition from:fact2-local-part3.xml
Added partition from:raw-local-part1.xml
Added partition from:raw-local-part2.xml
Added partition from:raw-local-part3.xml
Added partition from:raw-local-part4.xml
Added partition from:raw-local-part5.xml
Added partition from:raw-local-part6.xml
{noformat}
{noformat}
Query:select * from temp1
Status:FAILED:user lacks privilege or object not found: TEMP1 - Cause:null
Total time in millis:425
Driver run time in millis:8
{noformat}
Lensserver.log
{noformat}
14 Nov 2014 05:55:43,064 [QuerySubmitter] INFO org.apache.lens.driver.hive.HiveDriver - No more results closing the query
14 Nov 2014 05:55:43,067 [QuerySubmitter] INFO org.apache.lens.driver.hive.HiveDriver - CloseQuery: c8d0824e-55ba-430e-bcd2-7e03728126b4
14 Nov 2014 05:55:43,068 [QuerySubmitter] INFO hive.metastore - Trying to connect to metastore with URI thrift://localhost:9083
14 Nov 2014 05:55:43,068 [QuerySubmitter] INFO hive.metastore - Connected to metastore.
14 Nov 2014 05:55:43,092 [QuerySubmitter] ERROR hive.ql.metadata.Hive - NoSuchObjectException(message:dbcheck9.temp1 table not found)
at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$get_table_result$get_table_resultStandardScheme.read(ThriftHiveMetastore.java:29427)
at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$get_table_result$get_table_resultStandardScheme.read(ThriftHiveMetastore.java:29395)
at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$get_table_result.read(ThriftHiveMetastore.java:29326)
at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:78)
at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_get_table(ThriftHiveMetastore.java:1040)
at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.get_table(ThriftHiveMetastore.java:1026)
at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTable(HiveMetaStoreClient.java:1018)
at sun.reflect.GeneratedMethodAccessor19.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:622)
at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:89)
at com.sun.proxy.$Proxy10.getTable(Unknown Source)
at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:967)
at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:909)
at org.apache.lens.driver.hive.HiveQueryPlan.extractPlanDetails(HiveQueryPlan.java:191)
at org.apache.lens.driver.hive.HiveQueryPlan.<init>(HiveQueryPlan.java:108)
at org.apache.lens.driver.hive.HiveDriver.explain(HiveDriver.java:326)
at org.apache.lens.driver.hive.HiveDriver.explain(HiveDriver.java:71)
at org.apache.lens.server.api.query.DriverSelectorQueryContext.setDriverQueriesAndPlans(DriverSelectorQueryContext.java:76)
at org.apache.lens.server.query.QueryExecutionServiceImpl.rewriteAndSelect(QueryExecutionServiceImpl.java:915)
at org.apache.lens.server.query.QueryExecutionServiceImpl.access$800(QueryExecutionServiceImpl.java:89)
at org.apache.lens.server.query.QueryExecutionServiceImpl$QuerySubmitter.run(QueryExecutionServiceImpl.java:412)
at java.lang.Thread.run(Thread.java:701)
14 Nov 2014 05:55:43,092 [QuerySubmitter] ERROR org.apache.lens.server.api.query.DriverSelectorQueryContext - [Ljava.lang.StackTraceElement;@326fae9
14 Nov 2014 05:55:43,093 [QuerySubmitter] WARN org.apache.lens.driver.cube.RewriteUtil - lens.cube.query.driver.supported.storages value : mydb from query conf ignored/
{noformat}
> lens example queries failing on jdbc
> ------------------------------------
>
> Key: LENS-13
> URL: https://issues.apache.org/jira/browse/LENS-13
> Project: Apache Lens
> Issue Type: Bug
> Components: driver-jdbc
> Reporter: Arshad Matin
>
> Example queries for JDBC driver is failing as it is not able to find the table
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)