You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lens.apache.org by "Biru Kumar (JIRA)" <ji...@apache.org> on 2015/03/26 05:44:52 UTC
[jira] [Created] (LENS-448) getting ParseException when db and
dimension having same name
Biru Kumar created LENS-448:
-------------------------------
Summary: getting ParseException when db and dimension having same name
Key: LENS-448
URL: https://issues.apache.org/jira/browse/LENS-448
Project: Apache Lens
Issue Type: Bug
Components: test
Reporter: Biru Kumar
running below lens query
{noformat}
lens-shell>query execute cube select apps_owned from user
Launching query failed cause:Error while compiling statement: FAILED: ParseException line 1:186 cannot recognize input near 'user' 'join' 'user' in table source
{noformat}
lens server log
{noformat}
26 Mar 2015 04:44:19,512 [Grizzly-worker(8)] INFO org.apache.lens.server.LensServer.request - 31 * LoggingFilter - Request received on thread Grizzly-worker(8)
31 > POST http://0.0.0.0:9999/lensapi/queryapi/queries
31 > content-type: multipart/form-data; boundary=Boundary_4_1650759106_1427345059502
31 > user-agent: Jersey/2.3.1 (HttpUrlConnection 1.7.0_75)
31 > mime-version: 1.0
31 > host: 0.0.0.0:9999
31 > accept: text/html, image/gif, image/jpeg, *; q=.2, */*; q=.2
31 > connection: keep-alive
31 > content-length: 765
--Boundary_4_1650759106_1427345059502
Content-Type: application/xml
Content-Disposition: form-data; name="sessionid"
<?xml version="1.0" encoding="UTF-8" standalone="yes"?><lensSessionHandle><publicId>2e8a85e3-8d63-4ed2-94ff-67ddc80effb0</publicId><secretId>c70bde73-0899-4285-ac18-7304034e2686</secretId></lensSessionHandle>
--Boundary_4_1650759106_1427345059502
Content-Type: text/plain
Content-Disposition: form-data; name="query"
cube select apps_owned from user
--Boundary_4_1650759106_1427345059502
Content-Type: text/plain
Content-Disposition: form-data; name="operation"
execute
--Boundary_4_1650759106_1427345059502
Content-Type: text/plain
Content-Disposition: form-data; name="queryName"
--Boundary_4_1650759106_1427345059502--
==> lensserver.out.2015032513121427289176 <==
2015-03-26 04:44:19 INFO AuthenticationFilter:51 - Request from user: null, path=/queryapi/queries
2015-03-26 04:44:19 INFO QueryExecutionServiceImpl:1413 - ExecuteAsync: <?xml version="1.0" encoding="UTF-8" standalone="yes"?><lensSessionHandle><publicId>2e8a85e3-8d63-4ed2-94ff-67ddc80effb0</publicId><secretId>c70bde73-0899-4285-ac18-7304034e2686</secretId></lensSessionHandle> query: cube select apps_owned from user
2015-03-26 04:44:19 WARN LensSessionImpl:298 - DB resource service gave null class loader for user
2015-03-26 04:44:19 WARN LensSessionImpl:298 - DB resource service gave null class loader for user
2015-03-26 04:44:19,521 [pool-2-thread-3] INFO org.apache.lens.server.query.QueryExecutionServiceImpl$QueryStatusLogger - QueryEvent: QueryQueued:{id: 29e6824e-5948-438b-9595-97341442cb10, query:ab2f5971-6307-483a-8788-365a4af16bf7, change:[NEW -> QUEUED]}
2015-03-26 04:44:19 INFO QueryExecutionServiceImpl:1472 - Returning handle ab2f5971-6307-483a-8788-365a4af16bf7
==> lensserver-requests.log <==
26 Mar 2015 04:44:19,524 [Grizzly-worker(8)] INFO org.apache.lens.server.LensServer.request - 32 * LoggingFilter - Response received on thread Grizzly-worker(8)
32 < 200
32 < Content-Type: application/xml
<?xml version="1.0" encoding="UTF-8" standalone="yes"?><queryHandle><handleId>ab2f5971-6307-483a-8788-365a4af16bf7</handleId></queryHandle>
==> lensserver.out.2015032513121427289176 <==
2015-03-26 04:44:19 INFO QueryExecutionServiceImpl:465 - Launching query:cube select apps_owned from user
2015-03-26 04:44:19 WARN LensSessionImpl:298 - DB resource service gave null class loader for user
==> lensserver-requests.log <==
26 Mar 2015 04:44:19,578 [Grizzly-worker(2)] INFO org.apache.lens.server.LensServer.request - 33 * LoggingFilter - Request received on thread Grizzly-worker(2)
33 > GET http://0.0.0.0:9999/lensapi/queryapi/queries/ab2f5971-6307-483a-8788-365a4af16bf7?sessionid=%3C?xml+version%3D%221.0%22+encoding%3D%22UTF-8%22+standalone%3D%22yes%22?%3E%3ClensSessionHandle%3E%3CpublicId%3E2e8a85e3-8d63-4ed2-94ff-67ddc80effb0%3C/publicId%3E%3CsecretId%3Ec70bde73-0899-4285-ac18-7304034e2686%3C/secretId%3E%3C/lensSessionHandle%3E
33 > user-agent: Jersey/2.3.1 (HttpUrlConnection 1.7.0_75)
33 > host: 0.0.0.0:9999
33 > accept: text/html, image/gif, image/jpeg, *; q=.2, */*; q=.2
33 > connection: keep-alive
==> lensserver.out.2015032513121427289176 <==
2015-03-26 04:44:19 INFO AuthenticationFilter:51 - Request from user: null, path=/queryapi/queries/ab2f5971-6307-483a-8788-365a4af16bf7
2015-03-26 04:44:19 WARN LensSessionImpl:298 - DB resource service gave null class loader for user
2015-03-26 04:44:19 INFO ParseDriver:185 - Parsing command: cube select apps_owned from user
2015-03-26 04:44:19 INFO ParseDriver:206 - Parse Completed
2015-03-26 04:44:19 WARN LensSessionImpl:298 - DB resource service gave null class loader for user
2015-03-26 04:44:19 INFO ParseDriver:185 - Parsing command: cube select apps_owned from user
2015-03-26 04:44:19 INFO ParseDriver:206 - Parse Completed
2015-03-26 04:44:19 INFO CandidateTableResolver:136 - Populated candidate dims:[user_attributestore_er_dim_age_state, user_attributestore_er_dim_haschildren_state, user_attributestore_er_dim_gender_state] for user
2015-03-26 04:44:19 INFO DenormalizationResolver:144 - Adding denormalized column for column:apps_owned for table:user_attributestore_er_dim_age_state
2015-03-26 04:44:19 INFO CubeQueryContext:239 - Added join chain for hive_dimension_uac_app
2015-03-26 04:44:19 INFO CubeQueryContext:348 - Adding optional dimension:hive_dimension_uac_app optDim:CubeQueryContext.OptionalDimCtx(colQueried=[apptitle], requiredForCandidates=[user_attributestore_er_dim_age_state], isRequiredInJoinChain=false)
2015-03-26 04:44:19 INFO DenormalizationResolver:144 - Adding denormalized column for column:apps_owned for table:user_attributestore_er_dim_haschildren_state
2015-03-26 04:44:19 INFO CubeQueryContext:348 - Adding optional dimension:hive_dimension_uac_app optDim:CubeQueryContext.OptionalDimCtx(colQueried=[apptitle], requiredForCandidates=[user_attributestore_er_dim_age_state, user_attributestore_er_dim_haschildren_state], isRequiredInJoinChain=false)
2015-03-26 04:44:19 INFO DenormalizationResolver:144 - Adding denormalized column for column:apps_owned for table:user_attributestore_er_dim_gender_state
2015-03-26 04:44:19 INFO CubeQueryContext:348 - Adding optional dimension:hive_dimension_uac_app optDim:CubeQueryContext.OptionalDimCtx(colQueried=[apptitle], requiredForCandidates=[user_attributestore_er_dim_age_state, user_attributestore_er_dim_haschildren_state, user_attributestore_er_dim_gender_state], isRequiredInJoinChain=false)
2015-03-26 04:44:19 INFO CubeQueryContext:348 - Adding optional dimension:user_owned_apps optDim:CubeQueryContext.OptionalDimCtx(colQueried=[], requiredForCandidates=[], isRequiredInJoinChain=true)
2015-03-26 04:44:19 INFO CandidateTableResolver:70 - Populating optional dim:hive_dimension_uac_app
2015-03-26 04:44:19 INFO CandidateTableResolver:136 - Populated candidate dims:[hive_dimtable_uac_app] for hive_dimension_uac_app
2015-03-26 04:44:19 INFO CandidateTableResolver:70 - Populating optional dim:user_owned_apps
2015-03-26 04:44:19 INFO CandidateTableResolver:136 - Populated candidate dims:[user_attributestore_er_dim_bundleid_install, user_attributestore_er_dim_app_install, user_attributestore_er_dim_numbundleid_install, user_attributestore_er_dim_numbundlecategory_install] for user_owned_apps
2015-03-26 04:44:19 INFO StorageTableResolver:194 - Adding existing partitionlatest
2015-03-26 04:44:19 INFO StorageTableResolver:194 - Adding existing partitionlatest
2015-03-26 04:44:19 INFO StorageTableResolver:194 - Adding existing partitionlatest
2015-03-26 04:44:19 INFO StorageTableResolver:194 - Adding existing partitionlatest
2015-03-26 04:44:19 INFO StorageTableResolver:194 - Adding existing partitionlatest
2015-03-26 04:44:19 INFO StorageTableResolver:194 - Adding existing partitionlatest
2015-03-26 04:44:19 INFO StorageTableResolver:194 - Adding existing partitionlatest
2015-03-26 04:44:19 INFO StorageTableResolver:194 - Adding existing partitionlatest
2015-03-26 04:44:19 INFO CubeQueryContext:680 - Available candidate dims are:[user_attributestore_er_dim_age_state, user_attributestore_er_dim_haschildren_state, user_attributestore_er_dim_gender_state], picking up user_attributestore_er_dim_age_state for querying
2015-03-26 04:44:19 INFO DenormalizationResolver:184 - Picked reference for apps_owned ref:[DenormalizationResolver.PickedReference(ref=ReferencedDimAtrribute(references=[], isJoinKey=false, chainName=apps_owned, refColumn=apptitle), reference=null, srcAlias=user, pickedFor=user_attributestore_er_dim_age_state)]
2015-03-26 04:44:19 INFO CubeQueryContext:680 - Available candidate dims are:[hive_dimtable_uac_app], picking up hive_dimtable_uac_app for querying
2015-03-26 04:44:19 INFO JoinResolver:755 - pruning allPaths before generating all permutations.
2015-03-26 04:44:19 INFO JoinResolver:756 - allPaths: {Aliased(object=hive_dimension_uac_app, alias=apps_owned)=[[user_owned_apps.bundleid->hive_dimension_uac_app.bundleid, user.userid->user_owned_apps.userid]]}
2015-03-26 04:44:19 INFO JoinResolver:757 - qdims: [hive_dimension_uac_app, user]
2015-03-26 04:44:19 INFO JoinResolver:858 - Fact:null minCostClause:JoinResolver.JoinClause(cost=2, dimsInPath=[hive_dimension_uac_app, user_owned_apps], cubeql=org.apache.lens.cube.parse.CubeQueryContext@25ab4110, chain={Aliased(object=hive_dimension_uac_app, alias=apps_owned)=[user_owned_apps.bundleid->hive_dimension_uac_app.bundleid, user.userid->user_owned_apps.userid]}, joinTree=JoinResolver.JoinTree(parentRelationship=null, alias=user, subtrees={user.userid->user_owned_apps.userid=JoinResolver.JoinTree(parentRelationship=user.userid->user_owned_apps.userid, alias=user_owned_apps, subtrees={user_owned_apps.bundleid->hive_dimension_uac_app.bundleid=JoinResolver.JoinTree(parentRelationship=user_owned_apps.bundleid->hive_dimension_uac_app.bundleid, alias=apps_owned, subtrees={}, depthFromRoot=2, joinType=null)}, depthFromRoot=1, joinType=null)}, depthFromRoot=0, joinType=null), chainColumns={})
2015-03-26 04:44:19 INFO JoinResolver:878 - Not considering dimtable:user_attributestore_er_dim_app_install as its columns are not part of any join paths. Join columns:[bundleid, userid]
2015-03-26 04:44:19 INFO CubeQueryContext:680 - Available candidate dims are:[user_attributestore_er_dim_bundleid_install, user_attributestore_er_dim_numbundleid_install, user_attributestore_er_dim_numbundlecategory_install], picking up user_attributestore_er_dim_bundleid_install for querying
2015-03-26 04:44:19 INFO CubeQueryContext:811 - Picked Fact:null dimsToQuery:{hive_dimension_uac_app=hive_dimtable_uac_app, user_owned_apps=user_attributestore_er_dim_bundleid_install, user=user_attributestore_er_dim_age_state}
2015-03-26 04:44:19 INFO JoinResolver:432 - All paths dump:{Aliased(object=hive_dimension_uac_app, alias=apps_owned)=[[user_owned_apps.bundleid->hive_dimension_uac_app.bundleid, user.userid->user_owned_apps.userid]]}
2015-03-26 04:44:19 INFO RewriteUtil:315 - Final rewritten query for driver:org.apache.lens.driver.hive.HiveDriver@7ba19d2 is: SELECT ( apps_owned . apptitle ) FROM user.uh1_hdfs_user_attributestore_er_dim_age_state user join user.uh1_hdfs_user_attributestore_er_dim_bundleid_install user_owned_apps on user.userid = user_owned_apps.userid and (user_owned_apps.dt = 'latest') join user.uh1_hdfs_hive_dimtable_uac_app apps_owned on user_owned_apps.bundleid = apps_owned.bundleid and (apps_owned.dt = 'latest') WHERE ((((user.dt = 'latest'))))
2015-03-26 04:44:19 INFO HiveDriver:345 - Estimate: SELECT ( apps_owned . apptitle ) FROM user.uh1_hdfs_user_attributestore_er_dim_age_state user join user.uh1_hdfs_user_attributestore_er_dim_bundleid_install user_owned_apps on user.userid = user_owned_apps.userid and (user_owned_apps.dt = 'latest') join user.uh1_hdfs_hive_dimtable_uac_app apps_owned on user_owned_apps.bundleid = apps_owned.bundleid and (apps_owned.dt = 'latest') WHERE ((((user.dt = 'latest'))))
2015-03-26 04:44:19 INFO HiveDriver:845 - Hive driver query:INSERT OVERWRITE DIRECTORY "file:/tmp/lensreports/hdfsout/ab2f5971-6307-483a-8788-365a4af16bf7" SELECT ( apps_owned . apptitle ) FROM user.uh1_hdfs_user_attributestore_er_dim_age_state user join user.uh1_hdfs_user_attributestore_er_dim_bundleid_install user_owned_apps on user.userid = user_owned_apps.userid and (user_owned_apps.dt = 'latest') join user.uh1_hdfs_hive_dimtable_uac_app apps_owned on user_owned_apps.bundleid = apps_owned.bundleid and (apps_owned.dt = 'latest') WHERE ((((user.dt = 'latest'))))
2015-03-26 04:44:19 INFO HiveDriver:490 - whetherCalculatePriority: true
2015-03-26 04:44:19 INFO HiveDriver:377 - Explain: INSERT OVERWRITE DIRECTORY "file:/tmp/lensreports/hdfsout/ab2f5971-6307-483a-8788-365a4af16bf7" SELECT ( apps_owned . apptitle ) FROM user.uh1_hdfs_user_attributestore_er_dim_age_state user join user.uh1_hdfs_user_attributestore_er_dim_bundleid_install user_owned_apps on user.userid = user_owned_apps.userid and (user_owned_apps.dt = 'latest') join user.uh1_hdfs_hive_dimtable_uac_app apps_owned on user_owned_apps.bundleid = apps_owned.bundleid and (apps_owned.dt = 'latest') WHERE ((((user.dt = 'latest'))))
2015-03-26 04:44:19 INFO HiveDriver:845 - Hive driver query:EXPLAIN EXTENDED INSERT OVERWRITE DIRECTORY "file:/tmp/lensreports/hdfsout/ab2f5971-6307-483a-8788-365a4af16bf7" SELECT ( apps_owned . apptitle ) FROM user.uh1_hdfs_user_attributestore_er_dim_age_state user join user.uh1_hdfs_user_attributestore_er_dim_bundleid_install user_owned_apps on user.userid = user_owned_apps.userid and (user_owned_apps.dt = 'latest') join user.uh1_hdfs_hive_dimtable_uac_app apps_owned on user_owned_apps.bundleid = apps_owned.bundleid and (apps_owned.dt = 'latest') WHERE ((((user.dt = 'latest'))))
2015-03-26 04:44:19 INFO HiveDriver:1129 - No hive operation available for c91bdb87-be6f-45ef-802a-62b5d406acb5
2015-03-26 04:44:19 ERROR HiveDriver:500 - could not set priority for lens session id:2e8a85e3-8d63-4ed2-94ff-67ddc80effb0User query: cube select apps_owned from user
org.apache.lens.api.LensException: Error executing query
at org.apache.lens.driver.hive.HiveDriver.execute(HiveDriver.java:475)
at org.apache.lens.driver.hive.HiveDriver.explain(HiveDriver.java:386)
at org.apache.lens.driver.hive.HiveDriver.executeAsync(HiveDriver.java:494)
at org.apache.lens.server.query.QueryExecutionServiceImpl$QuerySubmitter.run(QueryExecutionServiceImpl.java:477)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: ParseException line 1:203 cannot recognize input near 'user' 'join' 'user' in table source
at org.apache.hive.service.cli.thrift.ThriftCLIServiceClient.checkStatus(ThriftCLIServiceClient.java:52)
at org.apache.hive.service.cli.thrift.ThriftCLIServiceClient.executeStatementInternal(ThriftCLIServiceClient.java:151)
at org.apache.hive.service.cli.thrift.ThriftCLIServiceClient.executeStatement(ThriftCLIServiceClient.java:129)
at sun.reflect.GeneratedMethodAccessor34.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.apache.hive.service.cli.thrift.RetryingThriftCLIServiceClient.invokeInternal(RetryingThriftCLIServiceClient.java:301)
at org.apache.hive.service.cli.thrift.RetryingThriftCLIServiceClient.invoke(RetryingThriftCLIServiceClient.java:329)
at com.sun.proxy.$Proxy50.executeStatement(Unknown Source)
at org.apache.hive.service.cli.thrift.RetryingThriftCLIServiceClient$CLIServiceClientWrapper.executeStatement(RetryingThriftCLIServiceClient.java:111)
at org.apache.lens.driver.hive.HiveDriver.execute(HiveDriver.java:452)
... 4 more
2015-03-26 04:44:19 INFO HiveDriver:1129 - No hive operation available for ab2f5971-6307-483a-8788-365a4af16bf7
2015-03-26 04:44:19 ERROR QueryExecutionServiceImpl:479 - Error launching query ab2f5971-6307-483a-8788-365a4af16bf7
org.apache.lens.api.LensException: Error executing async query
at org.apache.lens.driver.hive.HiveDriver.executeAsync(HiveDriver.java:513)
at org.apache.lens.server.query.QueryExecutionServiceImpl$QuerySubmitter.run(QueryExecutionServiceImpl.java:477)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: ParseException line 1:186 cannot recognize input near 'user' 'join' 'user' in table source
at org.apache.hive.service.cli.thrift.ThriftCLIServiceClient.checkStatus(ThriftCLIServiceClient.java:52)
at org.apache.hive.service.cli.thrift.ThriftCLIServiceClient.executeStatementInternal(ThriftCLIServiceClient.java:151)
at org.apache.hive.service.cli.thrift.ThriftCLIServiceClient.executeStatementAsync(ThriftCLIServiceClient.java:139)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.apache.hive.service.cli.thrift.RetryingThriftCLIServiceClient.invokeInternal(RetryingThriftCLIServiceClient.java:301)
at org.apache.hive.service.cli.thrift.RetryingThriftCLIServiceClient.invoke(RetryingThriftCLIServiceClient.java:329)
at com.sun.proxy.$Proxy50.executeStatementAsync(Unknown Source)
at org.apache.hive.service.cli.thrift.RetryingThriftCLIServiceClient$CLIServiceClientWrapper.executeStatementAsync(RetryingThriftCLIServiceClient.java:118)
at org.apache.lens.driver.hive.HiveDriver.executeAsync(HiveDriver.java:504)
... 2 more
2015-03-26 04:44:19,614 [pool-2-thread-4] INFO org.apache.lens.server.query.QueryExecutionServiceImpl$QueryStatusLogger - QueryEvent: QueryFailed:{id: d579f439-e6c2-4e2e-9aa7-9660e3188bde, query:ab2f5971-6307-483a-8788-365a4af16bf7, change:[QUEUED -> FAILED]}
==> lensserver-requests.log <==
26 Mar 2015 04:44:19,617 [Grizzly-worker(2)] INFO org.apache.lens.server.LensServer.request - 34 * LoggingFilter - Response received on thread Grizzly-worker(2)
34 < 200
34 < Content-Type: application/xml
<?xml version="1.0" encoding="UTF-8" standalone="yes"?><lensQuery><queryHandle><handleId>ab2f5971-6307-483a-8788-365a4af16bf7</handleId></queryHandle><userQuery>cube select apps_owned from user</userQuery><submittedUser>anonymous</submittedUser><priority>NORMAL</priority><isPersistent>false</isPersistent><selectedDriverClassName>org.apache.lens.driver.hive.HiveDriver</selectedDriverClassName><driverQuery>INSERT OVERWRITE DIRECTORY "file:/tmp/lensreports/hdfsout/ab2f5971-6307-483a-8788-365a4af16bf7" SELECT ( apps_owned . apptitle ) FROM user.uh1_hdfs_user_attributestore_er_dim_age_state user join user.uh1_hdfs_user_attributestore_er_dim_bundleid_install user_owned_apps on user.userid = user_owned_apps.userid and (user_owned_apps.dt = 'latest') join user.uh1_hdfs_hive_dimtable_uac_app apps_owned on user_owned_apps.bundleid = apps_owned.bundleid and (apps_owned.dt = 'latest') WHERE ((((user.dt = 'latest')))) </driverQuery><status><progress>0.0</progress><status>FAILED</status><statusMessage>Launching query failed</statusMessage><isResultSetAvailable>false</isResultSetAvailable><errorMessage>Error while compiling statement: FAILED: ParseException line 1:186 cannot recognize input near 'user' 'join' 'user' in table source</errorMessage></status><submissionTime>1427345059521</submissionTime><launchTime>0</launchTime><driverStartTime>0</driverStartTime><driverFinishTime>0</driverFinishTime><finishTime>1427345059614</finishTime><closedTime>0</closedTime><queryName></queryName></lensQuery>
26 Mar 2015 04:44:19,664 [Grizzly-worker(1)] INFO org.apache.lens.server.LensServer.request - 35 * LoggingFilter - Request received on thread Grizzly-worker(1)
35 > GET http://0.0.0.0:9999/lensapi/queryapi/queries/ab2f5971-6307-483a-8788-365a4af16bf7?sessionid=%3C?xml+version%3D%221.0%22+encoding%3D%22UTF-8%22+standalone%3D%22yes%22?%3E%3ClensSessionHandle%3E%3CpublicId%3E2e8a85e3-8d63-4ed2-94ff-67ddc80effb0%3C/publicId%3E%3CsecretId%3Ec70bde73-0899-4285-ac18-7304034e2686%3C/secretId%3E%3C/lensSessionHandle%3E
35 > user-agent: Jersey/2.3.1 (HttpUrlConnection 1.7.0_75)
35 > host: 0.0.0.0:9999
35 > accept: text/html, image/gif, image/jpeg, *; q=.2, */*; q=.2
35 > connection: keep-alive
==> lensserver.out.2015032513121427289176 <==
2015-03-26 04:44:19 INFO AuthenticationFilter:51 - Request from user: null, path=/queryapi/queries/ab2f5971-6307-483a-8788-365a4af16bf7
2015-03-26 04:44:19 WARN LensSessionImpl:298 - DB resource service gave null class loader for user
==> lensserver-requests.log <==
26 Mar 2015 04:44:19,670 [Grizzly-worker(1)] INFO org.apache.lens.server.LensServer.request - 36 * LoggingFilter - Response received on thread Grizzly-worker(1)
36 < 200
36 < Content-Type: application/xml
<?xml version="1.0" encoding="UTF-8" standalone="yes"?><lensQuery><queryHandle><handleId>ab2f5971-6307-483a-8788-365a4af16bf7</handleId></queryHandle><userQuery>cube select apps_owned from user</userQuery><submittedUser>anonymous</submittedUser><priority>NORMAL</priority><isPersistent>false</isPersistent><selectedDriverClassName>org.apache.lens.driver.hive.HiveDriver</selectedDriverClassName><driverQuery>INSERT OVERWRITE DIRECTORY "file:/tmp/lensreports/hdfsout/ab2f5971-6307-483a-8788-365a4af16bf7" SELECT ( apps_owned . apptitle ) FROM user.uh1_hdfs_user_attributestore_er_dim_age_state user join user.uh1_hdfs_user_attributestore_er_dim_bundleid_install user_owned_apps on user.userid = user_owned_apps.userid and (user_owned_apps.dt = 'latest') join user.uh1_hdfs_hive_dimtable_uac_app apps_owned on user_owned_apps.bundleid = apps_owned.bundleid and (apps_owned.dt = 'latest') WHERE ((((user.dt = 'latest')))) </driverQuery><status><progress>0.0</progress><status>FAILED</status><statusMessage>Launching query failed</statusMessage><isResultSetAvailable>false</isResultSetAvailable><errorMessage>Error while compiling statement: FAILED: ParseException line 1:186 cannot recognize input near 'user' 'join' 'user' in table source</errorMessage></status><submissionTime>1427345059521</submissionTime><launchTime>0</launchTime><driverStartTime>0</driverStartTime><driverFinishTime>0</driverFinishTime><finishTime>1427345059614</finishTime><closedTime>0</closedTime><queryName></queryName></lensQuery>
{noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)