We have a configuration CDH5.0,Spark1.1.0(stand alone) and hive0.12
We are trying to run some realtime analytics from Tableau8.1(BI Tool) and
one of the dashboard was failing with below error. Is it something to do
with the aggregate function not supported by spark-sql ?Any help
appreciated.
14/10/01 10:49:34 WARN thrift.ThriftCLIService: Error fetching results:
org.apache.hive.service.cli.HiveSQLException:
org.apache.spark.sql.catalyst.errors.package$TreeNodeException: Unresolved
attributes: 'c_6e6f6e655f61737369676e6d656e745f7374617475735f6e6b ASC, tree:
Sort ['c_6e6f6e655f61737369676e6d656e745f7374617475735f6e6b ASC]
Aggregate [assignment_status#1315], [assignment_status#1315 AS
`c_6e6f6e655f61737369676e6d656e745f7374617475735f6e6b`#1276]
LowerCaseSchema
MetastoreRelation default, tablename,
Some(c_637573746f6d65725f696e73696768745f66756c6c5f737061726b)
at
org.apache.spark.sql.hive.thriftserver.server.SparkSQLOperationManager$$anon$1.run(SparkSQLOperationManager.scala:201)
at
org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(HiveSessionImpl.java:193)
at
org.apache.hive.service.cli.session.HiveSessionImpl.executeStatement(HiveSessionImpl.java:175)
at
org.apache.hive.service.cli.CLIService.executeStatement(CLIService.java:150)
at
org.apache.hive.service.cli.thrift.ThriftCLIService.ExecuteStatement(ThriftCLIService.java:207)
at
org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1133)
at
org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1118)
at
org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
at
org.apache.hive.service.auth.TUGIContainingProcessor$1.run(TUGIContainingProcessor.java:58)
at
org.apache.hive.service.auth.TUGIContainingProcessor$1.run(TUGIContainingProcessor.java:55)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:415)
at
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1548)
at
org.apache.hadoop.hive.shims.HadoopShimsSecure.doAs(HadoopShimsSecure.java:526)
at
org.apache.hive.service.auth.TUGIContainingProcessor.process(TUGIContainingProcessor.java:55)
at
org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:206)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
14/10/01 10:49:34 INFO cli.CLIService: SessionHandle
[d7777446-3336-40fc-a4c9-7ce234a7e70a]: closeSession()
--
View this message in context:
http://apache-spark-user-list.1001560.n3.nabble.com/org-apache-spark-sql-catalyst-errors-package-TreeNodeException-tp15492.html
Sent from the Apache Spark User List mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscr...@spark.apache.org
For additional commands, e-mail: user-h...@spark.apache.org
