[
https://issues.apache.org/jira/browse/LENS-448?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Amareshwari Sriramadasu resolved LENS-448.
------------------------------------------
Resolution: Won't Fix
This is a limitation in Hive QL itself. Resolving as wont fix.
> 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)
