[ https://issues.apache.org/jira/browse/SPARK-28637?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Xiao Li resolved SPARK-28637. ----------------------------- Fix Version/s: 3.0.0 Assignee: Yuming Wang Resolution: Fixed > Thriftserver can not support interval type > ------------------------------------------ > > Key: SPARK-28637 > URL: https://issues.apache.org/jira/browse/SPARK-28637 > Project: Spark > Issue Type: Improvement > Components: SQL > Affects Versions: 3.0.0 > Reporter: Yuming Wang > Assignee: Yuming Wang > Priority: Major > Fix For: 3.0.0 > > > {code:sql} > 0: jdbc:hive2://localhost:10000> select interval '10-11' year to month; > Error: java.lang.IllegalArgumentException: Unrecognized type name: interval > (state=,code=0) > {code} > {code:sql} > spark-sql> select interval '10-11' year to month; > interval 10 years 11 months > {code} > Thriftserver log: > {noformat} > java.lang.RuntimeException: java.lang.IllegalArgumentException: Unrecognized > type name: interval > at > org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:83) > at > org.apache.hive.service.cli.session.HiveSessionProxy.access$000(HiveSessionProxy.java:36) > at > org.apache.hive.service.cli.session.HiveSessionProxy$1.run(HiveSessionProxy.java:63) > at > java.security.AccessController.doPrivileged(AccessController.java:770) > at javax.security.auth.Subject.doAs(Subject.java:422) > at > org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1746) > at > org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:59) > at com.sun.proxy.$Proxy26.getResultSetMetadata(Unknown Source) > at > org.apache.hive.service.cli.CLIService.getResultSetMetadata(CLIService.java:436) > at > org.apache.hive.service.cli.thrift.ThriftCLIService.GetResultSetMetadata(ThriftCLIService.java:607) > at > org.apache.hive.service.cli.thrift.TCLIService$Processor$GetResultSetMetadata.getResult(TCLIService.java:1533) > at > org.apache.hive.service.cli.thrift.TCLIService$Processor$GetResultSetMetadata.getResult(TCLIService.java:1518) > at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:38) > at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39) > at > org.apache.hive.service.auth.TSetIpAddressProcessor.process(TSetIpAddressProcessor.java:53) > at > org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:310) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) > at java.lang.Thread.run(Thread.java:819) > Caused by: java.lang.IllegalArgumentException: Unrecognized type name: > interval > at org.apache.hive.service.cli.Type.getType(Type.java:169) > at > org.apache.hive.service.cli.TypeDescriptor.<init>(TypeDescriptor.java:53) > at > org.apache.hive.service.cli.ColumnDescriptor.<init>(ColumnDescriptor.java:53) > at org.apache.hive.service.cli.TableSchema.<init>(TableSchema.java:52) > at > org.apache.spark.sql.hive.thriftserver.SparkExecuteStatementOperation$.getTableSchema(SparkExecuteStatementOperation.scala:314) > at > org.apache.spark.sql.hive.thriftserver.SparkExecuteStatementOperation.resultSchema$lzycompute(SparkExecuteStatementOperation.scala:69) > at > org.apache.spark.sql.hive.thriftserver.SparkExecuteStatementOperation.resultSchema(SparkExecuteStatementOperation.scala:64) > at > org.apache.spark.sql.hive.thriftserver.SparkExecuteStatementOperation.getResultSetSchema(SparkExecuteStatementOperation.scala:158) > at > org.apache.hive.service.cli.operation.OperationManager.getOperationResultSetSchema(OperationManager.java:209) > at > org.apache.hive.service.cli.session.HiveSessionImpl.getResultSetMetadata(HiveSessionImpl.java:773) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) > at > org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:78) > ... 18 more > {noformat} -- This message was sent by Atlassian Jira (v8.3.2#803003) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org