islandgit commented on issue #1898: URL: https://github.com/apache/iceberg/issues/1898#issuecomment-741886984
> @islandgit：我看不到任何命名的列`id`。您也可以发送确切的查询吗？ > > 谢谢彼得 @pvary sorry ， select * from table where id = 100 is just an example. The actual SQL **_select * from sinoiov_original_data where vehicle = 'AP3068';_** **This is the query information for Beeline，The error message above is the 'hive' query** INFO : Compiling command(queryId=hive_20201210002100_62b991d1-d5a6-40e1-835d-10f157291e0e): select * from sinoiov_original_data where vehicle = 'AP3068' INFO : Semantic Analysis Completed INFO : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:sinoiov_original_data.gpstime, type:bigint, comment:null), FieldSchema(name:sinoiov_original_data.systime, type:bigint, comment:null), FieldSchema(name:sinoiov_original_data.lon, type:int, comment:null), FieldSchema(name:sinoiov_original_data.lat, type:int, comment:null), FieldSchema(name:sinoiov_original_data.gpsspeed, type:int, comment:null), FieldSchema(name:sinoiov_original_data.direction, type:int, comment:null), FieldSchema(name:sinoiov_original_data.altitude, type:int, comment:null), FieldSchema(name:sinoiov_original_data.mileage, type:int, comment:null), FieldSchema(name:sinoiov_original_data.state, type:string, comment:null), FieldSchema(name:sinoiov_original_data.alarm, type:string, comment:null), FieldSchema(name:sinoiov_original_data.color, type:int, comment:null), FieldSchema(name:sinoiov_original_data.vehicle, type:string, comment:null), FieldSchema(name:sinoiov_original_data.p_time, type:timestamp, comment:null)], properties:null) INFO : Completed compiling command(queryId=hive_20201210002100_62b991d1-d5a6-40e1-835d-10f157291e0e); Time taken: 0.211 seconds INFO : Executing command(queryId=hive_20201210002100_62b991d1-d5a6-40e1-835d-10f157291e0e): select * from sinoiov_original_data where vehicle = 'AP3068' WARN : INFO : Query ID = hive_20201210002100_62b991d1-d5a6-40e1-835d-10f157291e0e INFO : Total jobs = 1 INFO : Launching Job 1 out of 1 INFO : Starting task [Stage-1:MAPRED] in serial mode INFO : Number of reduce tasks is set to 0 since there's no reduce operator INFO : Cleaning up the staging area /user/hive/.staging/job_1607332098484_0070 ERROR : FAILED: Execution Error, return code -101 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask. org.apache.hadoop.hive.ql.io.sarg.ConvertAstToSearchArg.create(Lorg/apache/hadoop/conf/Configuration;Lorg/apache/hadoop/hive/ql/plan/ExprNodeGenericFuncDesc;)Lorg/apache/hadoop/hive/ql/io/sarg/SearchArgument; INFO : Completed executing command(queryId=hive_20201210002100_62b991d1-d5a6-40e1-835d-10f157291e0e); Time taken: 1.329 seconds Error: Error while processing statement: FAILED: Execution Error, return code -101 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask. org.apache.hadoop.hive.ql.io.sarg.ConvertAstToSearchArg.create(Lorg/apache/hadoop/conf/Configuration;Lorg/apache/hadoop/hive/ql/plan/ExprNodeGenericFuncDesc;)Lorg/apache/hadoop/hive/ql/io/sarg/SearchArgument; (state=08S01,code=-101) ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
