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

[#1]

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?

[#2 · Accepted solution]

@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.

[#3]

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