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 2020/12/07 09:31:33 UTC
[GitHub] [iceberg] zuoyebushiwo opened a new issue #1884: hive document example is not work!
zuoyebushiwo opened a new issue #1884:
URL: https://github.com/apache/iceberg/issues/1884
CREATE EXTERNAL TABLE table_a (id BIGINT, data STRING)
STORED BY 'org.apache.iceberg.mr.hive.HiveIcebergStorageHandler'
LOCATION 'hdfs://HDFSCluster/warehouse/iceberg_db.db/table_a';
Error:
Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. java.lang.RuntimeException: MetaException(message:org.apache.hadoop.hive.serde2.SerDeException Please provide an existing table or a valid schema) (state=08S01,code=1)
How can i should.
----------------------------------------------------------------
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] zuoyebushiwo closed issue #1884: hive document example is not work!
Posted by GitBox <gi...@apache.org>.
zuoyebushiwo closed issue #1884:
URL: https://github.com/apache/iceberg/issues/1884
----------------------------------------------------------------
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] XuQianJin-Stars commented on issue #1884: hive document example is not work!
Posted by GitBox <gi...@apache.org>.
XuQianJin-Stars commented on issue #1884:
URL: https://github.com/apache/iceberg/issues/1884#issuecomment-740310274
hi @zuoyebushiwo You need to specify the schema information and perform the following operations to successfully create the table.
`
CREATE EXTERNAL TABLE customers STORED BY 'org.apache.iceberg.mr.hive.HiveIcebergStorageHandler' LOCATION 'hdfs://namenode:8020/cs/table_a' TBLPROPERTIES ('iceberg.mr.table.schema'='{"type":"struct","fields":[{"id":1,"name":"customer_id","required":false,"type":"long"},{"id":2,"name":"first_name","required":false,"type":"string"},{"id":3,"name":"last_name","required":false,"type":"string"}]}', 'iceberg.mr.table.partition.spec'='{"spec-id":0,"fields":[{"name":"customer_id","transform":"identity","source-id":1,"field-id":1000}]}', 'dummy'='test');
`
----------------------------------------------------------------
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] XuQianJin-Stars commented on issue #1884: hive document example is not work!
Posted by GitBox <gi...@apache.org>.
XuQianJin-Stars commented on issue #1884:
URL: https://github.com/apache/iceberg/issues/1884#issuecomment-740316429
> Did you create the Iceberg table first?
hi @RussellSpitzer Regarding this point, I think the document needs to be updated to further explain in detail.
----------------------------------------------------------------
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] zuoyebushiwo commented on issue #1884: hive document example is not work!
Posted by GitBox <gi...@apache.org>.
zuoyebushiwo commented on issue #1884:
URL: https://github.com/apache/iceberg/issues/1884#issuecomment-740350601
> > Did you create the Iceberg table first?
>
> hi @RussellSpitzer Regarding this point, I think the document needs to be updated to further explain in detail.
think very much! it help me a lot
----------------------------------------------------------------
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] RussellSpitzer commented on issue #1884: hive document example is not work!
Posted by GitBox <gi...@apache.org>.
RussellSpitzer commented on issue #1884:
URL: https://github.com/apache/iceberg/issues/1884#issuecomment-740145759
Did you create the Iceberg table first?
----------------------------------------------------------------
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] XuQianJin-Stars edited a comment on issue #1884: hive document example is not work!
Posted by GitBox <gi...@apache.org>.
XuQianJin-Stars edited a comment on issue #1884:
URL: https://github.com/apache/iceberg/issues/1884#issuecomment-740310274
hi @zuoyebushiwo There are two ways to successfully create a hive table:
1. Specify the schema information and perform the following operations to successfully create the table.
`
CREATE EXTERNAL TABLE customers STORED BY 'org.apache.iceberg.mr.hive.HiveIcebergStorageHandler' LOCATION 'hdfs://namenode:8020/cs/table_a' TBLPROPERTIES ('iceberg.mr.table.schema'='{"type":"struct","fields":[{"id":1,"name":"customer_id","required":false,"type":"long"},{"id":2,"name":"first_name","required":false,"type":"string"},{"id":3,"name":"last_name","required":false,"type":"string"}]}', 'iceberg.mr.table.partition.spec'='{"spec-id":0,"fields":[{"name":"customer_id","transform":"identity","source-id":1,"field-id":1000}]}', 'dummy'='test');
`
2.Create a hive external table on the hdfs path of the existing iceberg table.
`
CREATE EXTERNAL TABLE customers2 STORED BY 'org.apache.iceberg.mr.hive.HiveIcebergStorageHandler' LOCATION 'hdfs://namenode:8020/cs/table_a';
`
----------------------------------------------------------------
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