[
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)
