[SPARK-11067] Spark SQL thrift server fails to handle decimal value

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Incomplete
• Affects Version/s: 1.4.1
• Component/s: SQL
• Labels: bulk-closed
• Assignee: Unassigned
• Reporter: Alex Liu
• Created: 12/Oct/15 16:31
• Updated: 21/May/19 04:36
• Resolved: 21/May/19 04:36

Description

When executing the following query through beeline connecting to Spark sql thrift server, it errors out for decimal column

Select decimal_column from table


WARN  2015-10-09 15:04:00 org.apache.hive.service.cli.thrift.ThriftCLIService: Error fetching results: 
java.lang.ClassCastException: java.math.BigDecimal cannot be cast to org.apache.hadoop.hive.common.type.HiveDecimal
	at org.apache.hive.service.cli.ColumnValue.toTColumnValue(ColumnValue.java:174) ~[hive-service-0.13.1a.jar:0.13.1a]
	at org.apache.hive.service.cli.RowBasedSet.addRow(RowBasedSet.java:60) ~[hive-service-0.13.1a.jar:0.13.1a]
	at org.apache.hive.service.cli.RowBasedSet.addRow(RowBasedSet.java:32) ~[hive-service-0.13.1a.jar:0.13.1a]
	at org.apache.spark.sql.hive.thriftserver.SparkExecuteStatementOperation.getNextRowSet(Shim13.scala:144) ~[spark-hive-thriftserver_2.10-1.4.1.1.jar:1.4.1.1]
	at org.apache.hive.service.cli.operation.OperationManager.getOperationNextRowSet(OperationManager.java:192) ~[hive-service-0.13.1a.jar:0.13.1a]
	at org.apache.hive.service.cli.session.HiveSessionImpl.fetchResults(HiveSessionImpl.java:471) ~[hive-service-0.13.1a.jar:0.13.1a]
	at org.apache.hive.service.cli.CLIService.fetchResults(CLIService.java:405) ~[hive-service-0.13.1a.jar:0.13.1a]
	at org.apache.hive.service.cli.thrift.ThriftCLIService.FetchResults(ThriftCLIService.java:530) ~[hive-service-0.13.1a.jar:0.13.1a]
	at org.apache.hive.service.cli.thrift.TCLIService$Processor$FetchResults.getResult(TCLIService.java:1553) [hive-service-0.13.1a.jar:0.13.1a]
	at org.apache.hive.service.cli.thrift.TCLIService$Processor$FetchResults.getResult(TCLIService.java:1538) [hive-service-0.13.1a.jar:0.13.1a]
	at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) [libthrift-0.9.2.jar:0.9.2]
	at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39) [libthrift-0.9.2.jar:0.9.2]
	at org.apache.hive.service.auth.TSetIpAddressProcessor.process(TSetIpAddressProcessor.java:55) [hive-service-0.13.1a.jar:4.8.1-SNAPSHOT]
	at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:285) [libthrift-0.9.2.jar:0.9.2]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_55]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1.7.0_55]
	at java.lang.Thread.run(Thread.java:745) [na:1.7.0_55]

Issue Links

• links to: [Github] Pull Request #9107 (navis)