codejoyan edited a comment on issue #2852:
URL: https://github.com/apache/hudi/issues/2852#issuecomment-824269118


   Can we  add the jars while reading using Hive from beeline/hive cli and 
create the external table manually ? In that case the inputformatclasses will 
be visible to the HMS while creating of the table as well as reading?
   
   And while reading from beeline add the jars using the add jars command. 
   add JAR hdfs:///tmp/hudi-hadoop-mr-bundle-0.7.0.jar
   
   CREATE EXTERNAL TABLE  IF NOT EXISTS `default`.`TestTableHudiHive`( 
`_hoodie_commit_time` string, `_hoodie_commit_seqno` string, 
`_hoodie_record_key` string, `_hoodie_partition_path` string, 
`_hoodie_file_name` string, `col_1` string, `col_2` int, `col_3` int, `col_4` 
string, `col_5` string, `col_6` int, `col_7` bigint, `col_8` string, `col_9` 
bigint, `col_10` string, `cntry_cd` string, `bus_dt` DATE) PARTITIONED BY 
(`partitionpath` string) ROW FORMAT SERDE 
'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe' STORED AS 
INPUTFORMAT 'org.apache.hudi.hadoop.HoodieParquetInputFormat' OUTPUTFORMAT 
'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat' LOCATION 
'gs://XXXXXXX/test_table_tgt_04142021_1'


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


Reply via email to