You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@iceberg.apache.org by GitBox <gi...@apache.org> on 2021/06/09 05:33:03 UTC

[GitHub] [iceberg] aimenglin opened a new issue #2687: Could Hive use Time Travel if the overlay iceberg table is created as a Hadoop Table?

aimenglin opened a new issue #2687:
URL: https://github.com/apache/iceberg/issues/2687


   Hi Iceberg experts,
   
   I am wondering about if we could enjoy the gourmet of the Iceberg when we are using Hive (shell) when the underlying Iceberg Table was created as a *Hadoop Table*. 
   
   According to the documentation ([page](https://iceberg.apache.org/hive/#hive-read-support)) we could create a overlay table directly in Hive by the support from StorageHandler like:
   ```
   CREATE EXTERNAL TABLE table_a 
   STORED BY 'org.apache.iceberg.mr.hive.HiveIcebergStorageHandler' 
   LOCATION 'hdfs://some_bucket/some_path/table_a';
   ```
   But I am not sure after the creation, how to use (if it is available?) the cool features of Iceberg like Snapshot Read or doing some simple checking of its metadata tables like Snapshot, Manifests etc.
   
   Thanks for your attention in advance!
   
   Best
   
   


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


[GitHub] [iceberg] marton-bod commented on issue #2687: Could Hive use Time Travel if the overlay iceberg table is created as a Hadoop Table?

Posted by GitBox <gi...@apache.org>.
marton-bod commented on issue #2687:
URL: https://github.com/apache/iceberg/issues/2687#issuecomment-864976080


   I'm closing this issue. Thanks for reaching out. Feel free to post questions though, if any.


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


[GitHub] [iceberg] pvary closed issue #2687: Could Hive use Time Travel if the overlay iceberg table is created as a Hadoop Table?

Posted by GitBox <gi...@apache.org>.
pvary closed issue #2687:
URL: https://github.com/apache/iceberg/issues/2687


   


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


[GitHub] [iceberg] marton-bod commented on issue #2687: Could Hive use Time Travel if the overlay iceberg table is created as a Hadoop Table?

Posted by GitBox <gi...@apache.org>.
marton-bod commented on issue #2687:
URL: https://github.com/apache/iceberg/issues/2687#issuecomment-858006838


   Hi @aimenglin. Thanks for reaching out! Unfortunately we don't have support for Time Travel queries on the Hive side. Time Travel support would require the extension of the Hive query language which is not possible with the Hive versions (Hive 2.3 and Hive 3.1) that Iceberg depends on. Please refer to our more up-to-date documentation for the full feature set supported by Hive: https://github.com/apache/iceberg/blob/master/site/docs/hive.md


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


[GitHub] [iceberg] pvary closed issue #2687: Could Hive use Time Travel if the overlay iceberg table is created as a Hadoop Table?

Posted by GitBox <gi...@apache.org>.
pvary closed issue #2687:
URL: https://github.com/apache/iceberg/issues/2687


   


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


[GitHub] [iceberg] marton-bod commented on issue #2687: Could Hive use Time Travel if the overlay iceberg table is created as a Hadoop Table?

Posted by GitBox <gi...@apache.org>.
marton-bod commented on issue #2687:
URL: https://github.com/apache/iceberg/issues/2687#issuecomment-864976080


   I'm closing this issue. Thanks for reaching out. Feel free to post questions though, if any.


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


[GitHub] [iceberg] aimenglin commented on issue #2687: Could Hive use Time Travel if the overlay iceberg table is created as a Hadoop Table?

Posted by GitBox <gi...@apache.org>.
aimenglin commented on issue #2687:
URL: https://github.com/apache/iceberg/issues/2687#issuecomment-858082551


   @marton-bod Thank you for the guide. I'll look into it.


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