Jump to content

Talk:Data Platform/Systems/Cluster/Hive/Queries

From Wikitech
Latest comment: 6 years ago by Joal in topic Error position
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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)Reply

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)Reply