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/09/18 05:49:58 UTC
[GitHub] [iceberg] liuhd666 opened a new issue #3146: beeline query iceberg table error
liuhd666 opened a new issue #3146:
URL: https://github.com/apache/iceberg/issues/3146
0: jdbc:hive2://xxx:218> select * from iceberg_test;
INFO : Compiling command(queryId=hive_20210918134550_136a108f-6791-4c3a-ac0b-25cde234c7a7): select * from iceberg_test
INFO : Semantic Analysis Completed
INFO : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:iceberg_test.id, type:bigint, comment:null), FieldSchema(name:iceberg_test.name, type:string, comment:null)], properties:null)
INFO : Completed compiling command(queryId=hive_20210918134550_136a108f-6791-4c3a-ac0b-25cde234c7a7); Time taken: 1.196 seconds
INFO : Concurrency mode is disabled, not creating a lock manager
INFO : Executing command(queryId=hive_20210918134550_136a108f-6791-4c3a-ac0b-25cde234c7a7): select * from iceberg_test
INFO : Completed executing command(queryId=hive_20210918134550_136a108f-6791-4c3a-ac0b-25cde234c7a7); Time taken: 0.027 seconds
INFO : OK
Error: java.io.IOException: java.lang.ClassCastException: org.apache.iceberg.mr.mapred.Container cannot be cast to org.apache.iceberg.mr.mapred.Container (state=,code=0)
0: jdbc:hive2://xxx:218> set iceberg.mr.reuse.containers=true;
Error: Error while processing statement: Cannot modify iceberg.mr.reuse.containers at runtime. It is not in list of params that are allowed to be modified at runtime (state=42000,code=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.
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
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] Neo966 commented on issue #3146: beeline query iceberg table error
Posted by GitBox <gi...@apache.org>.
Neo966 commented on issue #3146:
URL: https://github.com/apache/iceberg/issues/3146#issuecomment-924496172
no, only one jar.
It works, but does not support field filtering. throw exception: java.lang.NoSuchMethodError: org.apache.hadoop.hive.ql.io.sarg.ConvertAstToSearchArg.create(Lorg/apache/hadoop/conf/Configuration;Lorg/apache/hadoop/hive/ql/plan/ExprNodeGenericFuncDesc;)Lorg/apache/hadoop/hive/ql/io/sarg/SearchArgument;
the official website say support 2.x and 3.1.2 hive version, only 2.3.8 and 3.1.2 version was fully tested?
--
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: issues-unsubscribe@iceberg.apache.org
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 commented on issue #3146: beeline query iceberg table error
Posted by GitBox <gi...@apache.org>.
pvary commented on issue #3146:
URL: https://github.com/apache/iceberg/issues/3146#issuecomment-922635497
Or alternatively 3.1.2
--
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: issues-unsubscribe@iceberg.apache.org
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 commented on issue #3146: beeline query iceberg table error
Posted by GitBox <gi...@apache.org>.
pvary commented on issue #3146:
URL: https://github.com/apache/iceberg/issues/3146#issuecomment-924583557
> the official website say support 2.x and 3.1.2 hive version, only 2.3.8 and 3.1.2 version was fully tested?
Those are the versions that the unit tests are run.
Maybe we should clarify in the doc. Good point!
--
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: issues-unsubscribe@iceberg.apache.org
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] Neo966 commented on issue #3146: beeline query iceberg table error
Posted by GitBox <gi...@apache.org>.
Neo966 commented on issue #3146:
URL: https://github.com/apache/iceberg/issues/3146#issuecomment-923027180
it's works, place the iceberg-hive-runtime-0.12.0 jar under the hive auxlib directory.
--
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: issues-unsubscribe@iceberg.apache.org
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 commented on issue #3146: beeline query iceberg table error
Posted by GitBox <gi...@apache.org>.
pvary commented on issue #3146:
URL: https://github.com/apache/iceberg/issues/3146#issuecomment-923091186
Maybe order of the jars in the classpath is different. Is there another iceberg jar on the classpath?
--
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: issues-unsubscribe@iceberg.apache.org
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] liuhd666 commented on issue #3146: beeline query iceberg table error
Posted by GitBox <gi...@apache.org>.
liuhd666 commented on issue #3146:
URL: https://github.com/apache/iceberg/issues/3146#issuecomment-922209122
sometimes report this error:
0: jdbc:hive2://xxx:218> select * from iceberg_test;
INFO : Compiling command(queryId=hive_20210918134550_136a108f-6791-4c3a-ac0b-25cde234c7a7): select * from iceberg_test
INFO : Semantic Analysis Completed
INFO : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:iceberg_test.id, type:bigint, comment:null), FieldSchema(name:iceberg_test.name, type:string, comment:null)], properties:null)
INFO : Completed compiling command(queryId=hive_20210918134550_136a108f-6791-4c3a-ac0b-25cde234c7a7); Time taken: 1.196 seconds
INFO : Concurrency mode is disabled, not creating a lock manager
INFO : Executing command(queryId=hive_20210918134550_136a108f-6791-4c3a-ac0b-25cde234c7a7): select * from iceberg_test
INFO : Completed executing command(queryId=hive_20210918134550_136a108f-6791-4c3a-ac0b-25cde234c7a7); Time taken: 0.027 seconds
INFO : OK
Error: java.io.IOException: java.lang.ClassCastException: org.apache.iceberg.mr.mapred.Container cannot be cast to org.apache.iceberg.mr.mapred.Container (state=,code=0)
0: jdbc:hive2://xxx:218> set iceberg.mr.reuse.containers=true;
Error: Error while processing statement: Cannot modify iceberg.mr.reuse.containers at runtime. It is not in list of params that are allowed to be modified at runtime (state=42000,code=1)
hive version:2.1.1
create table ddl:
CREATE TABLE iceberg_test(id bigint, name string) STORED BY 'org.apache.iceberg.mr.hive.HiveIcebergStorageHandler';
--
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: issues-unsubscribe@iceberg.apache.org
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] MrSuperLi commented on issue #3146: beeline query iceberg table error
Posted by GitBox <gi...@apache.org>.
MrSuperLi commented on issue #3146:
URL: https://github.com/apache/iceberg/issues/3146#issuecomment-922322841
Have you found a solution? I have the same problem
--
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: issues-unsubscribe@iceberg.apache.org
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 commented on issue #3146: beeline query iceberg table error
Posted by GitBox <gi...@apache.org>.
pvary commented on issue #3146:
URL: https://github.com/apache/iceberg/issues/3146#issuecomment-922635362
Could you please try this with Hive 2.3.8? We do all of the testing with that version.
Thanks, Peter
--
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: issues-unsubscribe@iceberg.apache.org
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] wangmiao1002 commented on issue #3146: beeline query iceberg table error
Posted by GitBox <gi...@apache.org>.
wangmiao1002 commented on issue #3146:
URL: https://github.com/apache/iceberg/issues/3146#issuecomment-1074969808
I also encountered the same problem. I tried to solve it in this way. At present, the test is successful. I don't know whether it is reasonable or not.
Put iceberg-hive-runtime-0.13.1 jar in hive_ AUX_ JARS_ Path configuration directory;
Recompile the hive runtime module and modify the dependencies in the project to version 2.1.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.
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
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