[GitHub] [hudi] Carl-Zhou-CN commented on issue #4267: [SUPPORT] Hudi partition values not getting reflected in Athena

2021-12-12 Thread GitBox


Carl-Zhou-CN commented on issue #4267:
URL: https://github.com/apache/hudi/issues/4267#issuecomment-992178782


   I think it is possible, but I am not familiar with Athena. I think that as 
long as Hudi can interact with Glue Catalog, your problem should be solved. You 
may need to ask others to help.
   @nsivabalan Do you have time to help?


-- 
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: commits-unsubscr...@hudi.apache.org

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




[GitHub] [hudi] Carl-Zhou-CN commented on issue #4267: [SUPPORT] Hudi partition values not getting reflected in Athena

2021-12-12 Thread GitBox


Carl-Zhou-CN commented on issue #4267:
URL: https://github.com/apache/hudi/issues/4267#issuecomment-992150191


   @Arun-kc  Sorry, it seems I misunderstood,what needs to be done should be   
ALTER TABLE ADD PARTITION
   
![image](https://user-images.githubusercontent.com/67902676/145762846-007866d1-1bfe-46fe-b082-66e723007b92.png)
   
![image](https://user-images.githubusercontent.com/67902676/145762903-7599f309-b5b0-4eac-9e7c-d3b9ecafe9b8.png)
   
   
https://docs.aws.amazon.com/athena/latest/ug/querying-hudi.html#querying-hudi-in-athena-creating-hudi-tables


-- 
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: commits-unsubscr...@hudi.apache.org

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




[GitHub] [hudi] Carl-Zhou-CN commented on issue #4267: [SUPPORT] Hudi partition values not getting reflected in Athena

2021-12-11 Thread GitBox


Carl-Zhou-CN commented on issue #4267:
URL: https://github.com/apache/hudi/issues/4267#issuecomment-991840276


   hoodie.datasource.hive_sync.use_jdbc  -> false  Try to prohibit the 
connection to hive through jdbc?


-- 
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: commits-unsubscr...@hudi.apache.org

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




[GitHub] [hudi] Carl-Zhou-CN commented on issue #4267: [SUPPORT] Hudi partition values not getting reflected in Athena

2021-12-09 Thread GitBox


Carl-Zhou-CN commented on issue #4267:
URL: https://github.com/apache/hudi/issues/4267#issuecomment-990654733


   Because of your hudi version, you may need to manually update the partition 
after writing
   ALTER TABLE table_name RECOVER PARTITIONS;


-- 
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: commits-unsubscr...@hudi.apache.org

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




[GitHub] [hudi] Carl-Zhou-CN commented on issue #4267: [SUPPORT] Hudi partition values not getting reflected in Athena

2021-12-09 Thread GitBox


Carl-Zhou-CN commented on issue #4267:
URL: https://github.com/apache/hudi/issues/4267#issuecomment-990644240


   "hoodie.datasource.hive_sync.enable": "true",
   "hoodie.datasource.hive_sync.table": "my_hudi_table",
   "hoodie.datasource.hive_sync.partition_fields": "creation_date",
   "hoodie.datasource.hive_sync.partition_extractor_class": 
"org.apache.hudi.hive.MultiPartKeysValueExtractor",
   
   @Arun-kc If you do not register your Hudi dataset as a table in the Hive 
metastore, these options are not required.
   
   


-- 
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: commits-unsubscr...@hudi.apache.org

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




[GitHub] [hudi] Carl-Zhou-CN commented on issue #4267: [SUPPORT] Hudi partition values not getting reflected in Athena

2021-12-09 Thread GitBox


Carl-Zhou-CN commented on issue #4267:
URL: https://github.com/apache/hudi/issues/4267#issuecomment-990576501


   @Arun-kc It feels like a connection problem, please check 
hoodie.datasource.hive_sync.jdbcurl, it seems to be a default value now


-- 
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: commits-unsubscr...@hudi.apache.org

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