使用ODBC或JDBC來從一個表讀取失敗,當我試圖使用ORDER BY子句。在一個樣本的案例中,我有一個相當小的表(1946行)。
select * from some_table some_field秩序
結果:
. lang。IllegalArgumentException:要求失敗:子查詢子查詢# 485,(id = # 937)沒有完成org.apache.spark.sql.hive.thriftserver.HiveThriftServerErrors .runningQueryError美元(HiveThriftServerErrors.scala: 53) org.apache.spark.sql.hive.thriftserver.SparkExecuteStatementOperation.org apache引發美元sql蜂巢thriftserver SparkExecuteStatementOperation $ $美元美元執行(SparkExecuteStatementOperation.scala: 445) org.apache.spark.sql.hive.thriftserver.SparkExecuteStatementOperation $ $ $ $不久2美元立刻3美元。anonfun運行2美元美元(SparkExecuteStatementOperation.scala: 269) scala.runtime.java8.JFunction0專門sp.apply美元(JFunction0專門sp.java美元:23)在org.apache.spark.sql.hive.thriftserver.ThriftLocalProperties.withLocalProperties (ThriftLocalProperties.scala: 123) org.apache.spark.sql.hive.thriftserver.ThriftLocalProperties.withLocalProperties (ThriftLocalProperties.scala: 48)美元org.apache.spark.sql.hive.thriftserver.SparkExecuteStatementOperation.withLocalProperties (SparkExecuteStatementOperation.scala: 54) org.apache.spark.sql.hive.thriftserver.SparkExecuteStatementOperation不久2美元立刻3.美元美元運行(SparkExecuteStatementOperation.scala: 247) org.apache.spark.sql.hive.thriftserver.SparkExecuteStatementOperation不久2美元立刻3.美元美元運行(java.security.AccessController SparkExecuteStatementOperation.scala: 232)。doPrivileged(本機方法)javax.security.auth.Subject.doAs (Subject.java: 422) org.apache.hadoop.security.UserGroupInformation.doAs (UserGroupInformation.java: 1878) org.apache.spark.sql.hive.thriftserver.SparkExecuteStatementOperation不久美元2.美元(SparkExecuteStatementOperation.scala: 281)運行java.util.concurrent.Executors RunnableAdapter.call美元(Executors.java: 511) java.util.concurrent.FutureTask.run (FutureTask.java: 266) java.util.concurrent.ThreadPoolExecutor.runWorker (ThreadPoolExecutor.java: 1149)美元java.util.concurrent.ThreadPoolExecutor Worker.run (ThreadPoolExecutor.java: 624) java.lang.Thread.run (Thread.java: 750)美元scala.Predef .require (Predef.scala: 281) org.apache.spark.sql.execution.ScalarSubquery.eval (subquery.scala: 100) org.apache.spark.sql.catalyst.expressions.Alias.eval (namedExpressions.scala: 160)
這似乎很奇怪我不能運行一個簡單的ORDER BY子句?
我試著用ODBC驅動程序和JDBC (2.6.32)。使用JDBC,我嚐試了所有三種模式UseNativeQuery(0, 1, 2)排氣的所有選項。我沒有任何查詢超時指定,雖然指定一個超時值沒有大的區別。
最直接的印象是JDBC驅動程序出了問題,當然如果我丟失的東西明顯,這將是所有的,它似乎是一個驚人的錯誤。如果這真的是一個錯誤,我去報告在哪裏?
