ShubhamHAgrawal
ShubhamHAgrawal

Reputation: 1014

Presto error while querying hive table

  1. Querying select * from table_name limit 10; in Hive returns correct data. But querying same table through presto connection returns below error :

Presto query has failed. cannot find field from [0:error_error_error_error_error_error_error, 1:cannot_determine_schema, 2:check, 3:schema, 4:url, 5:and, 6:literal]

  1. Querying select count(*) from table_name; in Hive returns correct data. But querying the same table through presto connection returns below error :

Presto query has failed. HIVE_CURSOR_ERROR

I have gone through this link1 and link2 already but it did not help me.

Upvotes: 0

Views: 949

Answers (1)

ShubhamHAgrawal
ShubhamHAgrawal

Reputation: 1014

I have solved this issue by correcting avro schema.

Upvotes: 0

Related Questions