presto: "TextInputFormat" error when select table from external tables in Hive
Hi everyone,
I’m using presto-server-0.183, my Hadoop version is hadoop-2.6.4 and Hive version is hive-2.1.
When I execute query in presto-cli, I got no error with ORC table except external tables. There was the error log:
presto:default> select * from sms_123 limit 10;
Query 20170825_104145_00010_8qgyk failed: Unable to create input format org.apache.hadoop.mapred.TextInputFormat
and table sms_123 was an external table.
Does anyone knows how to fix it?
About this issue
- Original URL
- State: closed
- Created 7 years ago
- Reactions: 4
- Comments: 18 (10 by maintainers)
I solved it yesterday, but I don’t know why. And my presto version is [0.175.tar.gz] My presto cluster has five nodes, node1 is Master Node，The other four nodes is worker. in every node’s etc/catalog hive.properties , as follows: connector.name=hive-hadoop2 hive.metastore.uri=thrift://node1:9083 hive.compression-codec=NONE hive.allow-drop-table=false hive.allow-rename-table=false hive.allow-add-column=false hive.allow-rename-column=false so, you can try to delete “hive.config.resources=…”. I can already query in presto cli ,but I don’t why.