anvanna opened a new issue, #8891:
URL: https://github.com/apache/iceberg/issues/8891

   I am testing iceberg table as below with hive version 3.x and Tez version 
0.9.x
   
   - Hive engine running on Tez
   +----------------------------+
   |            set             |
   +----------------------------+
   | hive.execution.engine=tez  |
   +----------------------------+
   1 row selected (0.173 seconds)
   
   SET iceberg.catalog.hadoop_cat.type=hadoop;
   SET 
iceberg.catalog.hadoop_cat.warehouse=hdfs://hadoop-master:8020/hadoop_cat;
   SET iceberg.engine.hive.enabled=true
   SET hive.vectorized.execution.enabled=false;
   
   CREATE TABLE table_a (
     id bigint, name string
   ) PARTITIONED BY (
     dept string
   ) STORED BY 'org.apache.iceberg.mr.hive.HiveIcebergStorageHandler'
   TBLPROPERTIES ('iceberg.catalog'='hadoop_cat');
   
   insert into table_a values (1000, 'ABC');
   
   0: jdbc:hive2://hadoop-master:2> select * from table_a;
   INFO  : Compiling 
command(queryId=hive_20231020173641_a356d662-46fa-4503-893d-99b3ef2f96e2): 
select * from table_a
   INFO  : Semantic Analysis Completed (retrial = false)
   INFO  : Returning Hive schema: 
Schema(fieldSchemas:[FieldSchema(name:table_g.id, type:bigint, comment:null), 
FieldSchema(name:table_g.name, type:string, comment:null)], properties:null)
   INFO  : Completed compiling 
command(queryId=hive_20231020173641_a356d662-46fa-4503-893d-99b3ef2f96e2); Time 
taken: 3.292 seconds
   INFO  : Executing 
command(queryId=hive_20231020173641_a356d662-46fa-4503-893d-99b3ef2f96e2): 
select * from table_a
   INFO  : Completed executing 
command(queryId=hive_20231020173641_a356d662-46fa-4503-893d-99b3ef2f96e2); Time 
taken: 0.0 seconds
   INFO  : OK
   +-------------+---------------+
   | table_a.id  | table_a.name  |
   +-------------+---------------+
   +-------------+---------------+
   No rows selected (3.477 seconds)
   
   
   Why no result return?
   


-- 
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.

To unsubscribe, e-mail: issues-unsubscr...@iceberg.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@iceberg.apache.org
For additional commands, e-mail: issues-h...@iceberg.apache.org

Reply via email to