[GitHub] [hudi] codejoyan edited a comment on issue #2852: [SUPPORT] Read Hudi Table from Hive - Hive Sync clarification

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

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