Talk:Analytics/Systems/Cluster/Hive/Queries

From Wikitech
Jump to navigation Jump to search

Error position

Is there some way to find at what HQL position an error happened? I usually get super generic errors like org.apache.avro.AvroTypeException: Found long, expecting union which make it hard to figure it out which part of the query has a problem. --tgr (talk) 01:30, 10 December 2018 (UTC)

AFAIK only sql-syntax-related errors provide position pointing. The types error or other type of inner-job errors don't. One solution might be to look at job-logs in Yarn using yarn logs --application_id YOUR_APP_ID from a stat machine (pro-tip: pipe-grep or pipe-less, output shall be verbose). I am however not sure the output would be more precise. --Joal (talk) 09:08, 10 December 2018 (UTC)