Teradata
Describe works, but select does not
I have set up two virtual machines. One with Teradata presto 203 (on redhat linux 7), and other with HDP 2.6 from the Kylo VM. When I run describe from presto on a managed table, it works fine. But select gives me an error. Please see the below log :
presto> use hive.toy_store; USE presto:toy_store> describe products; Column | Type | Extra | Comment --------------------+---------+-------+--------- productcode | varchar | | productname | varchar | | productline | varchar | | productscale | varchar | | productvendor | varchar | | productdescription | varchar | | quantityinstock | varchar | | buyprice | double | | msrp | double | | processing_dttm | varchar | | (10 rows)
Query 20180904_150104_00021_zhvt9, FINISHED, 1 node Splits: 19 total, 19 done (100.00%) 0:01 [10 rows, 746B] [13 rows/s, 998B/s]
presto:toy_store> select count(*) from products;
Query 20180904_150115_00022_zhvt9, FAILED, 1 node Splits: 17 total, 0 done (0.00%) 0:00 [0 rows, 0B] [0 rows/s, 0B/s]
Query 20180904_150115_00022_zhvt9 failed: Failed to list directory: hdfs://sandbox.kylo.io:8020/app/warehouse/toy_store/products
I have checked all permissions, modified the users - but none of them worked. I added the hive config properties as well to see if it works, but it did not.
Please suggest if I have missed on any properties to tap into.
