Skip to content

Instantly share code, notes, and snippets.

@hrushikesh198

hrushikesh198/HIVE-Error-NullPointer.md

Last active February 5, 2017 10:27
Show Gist options
  • Save hrushikesh198/bb9c09c7f186fc5512784480bf0a5216 to your computer and use it in GitHub Desktop.
Save hrushikesh198/bb9c09c7f186fc5512784480bf0a5216 to your computer and use it in GitHub Desktop.
Download ZIP
HIVE Error FAILED: NullPointerException null [cause] None
Raw
HIVE-Error-NullPointer.md

Sometimes hive error message can be useless. It just says FAILED: NullPointerException null [cause] None. I wanted to note few such experience.

  • Select columns missing commas
SELECT
  col1
  col2
  col3
FROM
  table1
  • Unions with different column name
SELECT
  col1
  col2
FROM
  table1
UNION ALL
SELECT
  col1
  col2 as b
FROM
  table2
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment