Explore service hides the actual error message
Description
Release Notes
None
Activity
Show:
Cannot Reproduce
Pinned fields
Click on the next to a field label to start pinning.
Created October 9, 2014 at 11:17 PM
Updated March 27, 2015 at 7:30 PM
Resolved February 16, 2015 at 9:51 PM
When I send a bad query to Explore, I always get the exact same error message:
$ cdap-cli.sh execute "describe cdap_user_bouncecountsto"
Error: 409: The query is not well-formed or contains an error, such as a nonexistent table name: describe cdap_user_bouncecountsto
$ cdap-cli.sh execute "select * fro cdap_user_bouncecountstore"
Error: 409: The query is not well-formed or contains an error, such as a nonexistent table name: select * fro cdap_user_bouncecountstore
However, Hive does produce quite detailed error messages about bad queries, and they get logged, for example :
2014-10-09 16:11:28,707 - DEBUG [executor-12:c.c.c.e.e.QueryExecutorHttpHandler@94] - Got exception:
org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: SemanticException [Error 10001]: Table not found cdap_user_bouncecountsto
These detailed messages should be returned to the CLI (or HTTP client).