[GitHub] [iceberg] butaozhang commented on issue #2576: (Hive) insert overwrite table xxx partition (pt='xxx') on iceberg table

[GitBox <gi...@apache.org>]

butaozhang commented on issue #2576:
URL: https://github.com/apache/iceberg/issues/2576#issuecomment-837659767


   Hi @RussellSpitzer @marton-bod . I have test "Hive-iceberg-handler" module of  Hive master branch. Here are the test steps:
   1, **Create the ice table using hive beelin:**
     CREATE EXTERNAL TABLE ice_tbl (i int) STORED BY 'org.apache.iceberg.mr.hive.HiveIcebergStorageHandler';
   2**, Make a insert DDL:**
     set hive.execution.engine=mr;
     insert overwrite table ice_tbl values(1);
   3,**Make a select statement of ice_tbl, but found no data:**
   __0: jdbc:hive2://hivenode:10000> select * from ice_tbl;
   
   INFO  : Compiling command(queryId=hive_20210511100644_a0676d7a-11ac-4c69-8b03-ee081ec33f70): select * from ice_tbl
   INFO  : No Stats for default@ice_tbl, Columns: i
   INFO  : Semantic Analysis Completed (retrial = false)
   INFO  : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:ice_tbl.i, type:int, comment:null)], properties:null)
   INFO  : Completed compiling command(queryId=hive_20210511100644_a0676d7a-11ac-4c69-8b03-ee081ec33f70); Time taken: 0.28 seconds
   INFO  : Concurrency mode is disabled, not creating a lock manager
   INFO  : Executing command(queryId=hive_20210511100644_a0676d7a-11ac-4c69-8b03-ee081ec33f70): select * from ice_tbl
   INFO  : Completed executing command(queryId=hive_20210511100644_a0676d7a-11ac-4c69-8b03-ee081ec33f70); Time taken: 0.0 seconds
   +------------+
   | ice_tbl.i  |
   +------------+
   +------------+
   No rows selected (0.36 seconds)__
   
   
   So, Why is no data returned?  Am I missing some hive_iceberg configuration?  
   


-- 
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:
users@infra.apache.org



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