Describe works, but select does not

[tdcb]

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.