Support Questions
Find answers, ask questions, and share your expertise

FAILED: SemanticException org.apache.hadoop.hive.ql.parse.SemanticException

Solved Go to solution
Highlighted

FAILED: SemanticException org.apache.hadoop.hive.ql.parse.SemanticException

Explorer

I was following the tutorial to create a table Truck_Mileage from Existing Trucking Data, using the Ambari Hive View 2.0, executing the following query (see attachment). However, received a status 500 error. Please see attachment for details. Any ideas?

64831-hortonworks-query-failed.png

64829-hortonworks-query.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: FAILED: SemanticException org.apache.hadoop.hive.ql.parse.SemanticException

@Cathy Liu

The table you are trying to create already exists :)

Either use the existing table or drop the table and recreate it if you want it afresh!

Let know if you need any other help.

View solution in original post

2 REPLIES 2
Highlighted

Re: FAILED: SemanticException org.apache.hadoop.hive.ql.parse.SemanticException

@Cathy Liu

The table you are trying to create already exists :)

Either use the existing table or drop the table and recreate it if you want it afresh!

Let know if you need any other help.

View solution in original post

Re: FAILED: SemanticException org.apache.hadoop.hive.ql.parse.SemanticException

Explorer

Thank you; figured that out as I was going through the tutorial.