[GitHub] [hudi] hellochueng commented on issue #3795: [SUPPORT] hive query hudi error

Tue, 16 Nov 2021 19:17:56 -0800 


hellochueng commented on issue #3795:
URL: https://github.com/apache/hudi/issues/3795#issuecomment-971137251


   CREATE EXTERNAL TABLE flink_hudi_hive_test1(
       id INT, test1 STRING, test2 STRING, test3 STRING
   ) ROW FORMAT SERDE 
'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'  
   STORED AS INPUTFORMAT 
'org.apache.hudi.hadoop.realtime.HoodieParquetRealtimeInputFormat'
   OUTPUTFORMAT 
'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat' 
   LOCATION 'hdfs://idc-bigdata-185-56.jdy.kd.internal/hudi/flink_hudi_cdc4'; 
   
   set hive.execution.engine=mr;
   set hive.input.format=org.apache.hudi.hadoop.HoodieParquetInputFormat;
   
   When running
   [select * from flink_hudi_hive_test1 where id > 30000] 
   
![image](https://user-images.githubusercontent.com/29030883/142128062-3a5076a2-62d0-4aec-9341-dd6d3096cc79.png)
   
   [select count(*) from flink_hudi_hive_test1]
   
![image](https://user-images.githubusercontent.com/29030883/142128216-e60df713-34b1-4b3f-b49d-569b35819d86.png)
   
   
   


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to