hadoop - Presto Query HIVE Table Exception: Failed to list directory -
i'm new presto. have 2 machine presto 0.160, 1 coordinator, other worker. want query table in hive. can "show tables", "desc tablename", when want "select * tablename", exception occured: "query 20170728_123013_00011_q4s3a failed: failed list directory: hdfs://cdh-test/user/hive/warehouse/employee_hive"
presto> desc hive.default.employee_hive; column | type | comment -------------+---------+--------- eid | integer | name | varchar | salary | varchar | destination | varchar | (4 rows) query 20170728_123001_00010_q4s3a, finished, 2 nodes splits: 2 total, 2 done (100.00%) 0:00 [4 rows, 268b] [40 rows/s, 2.68kb/s] presto> select * hive.default.employee_hive; query 20170728_123013_00011_q4s3a, failed, 1 node splits: 1 total, 0 done (0.00%) 0:00 [0 rows, 0b] [0 rows/s, 0b/s] query 20170728_123013_00011_q4s3a failed: failed list directory: hdfs://cdh-test/user/hive/warehouse/employee_hive
here configuration hive catalog:
connector.name=hive-cdh4 hive.metastore.uri=thrift://***:9083 hive.config.resources=/etc/hadoop/conf/core-site.xml,/etc/hadoop/conf/hdfs-site.xml
where wrong?
the path table stored on needs exist on hdfs presto open successfully. path appears table "internal" hive table, meaning hive should have created path itself. since hasn't, create using command similar hdfs dfs -mkdir hdfs://cdh-test/user/hive/warehouse/employee_hive
, although exact command depends on hdfs set up.
Comments
Post a Comment