org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: SemanticException [Error 10004]:

[#1]

I am following sandbox tutorial in hortonworks site. While creating truck_mileage table I am getting the below error message in Hive View in Ambari.

org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: SemanticException [Error 10004]: Line 1:148 Invalid table alias or column reference 'jun13_miles': (possible column names are: column1, column2, column3, column4, column5, column6, column7, column8, column9, column10, column11, column12, column13, column14, column15, column16, column17, column18, column19, column20, column21, column22, column23, column24, column25, column26, column27, column28, column29, column30, column31, column32, column33, column34, column35, column36, column37, column38, column39, column40, column41, column42, column43, column44, column45, column46, column47, column48, column49, column50, column51, column52, column53, column54, column55, column56, column57, column58, column59, column60, column61, column62, column63, column64, column65, column66, column67, column68, column69, column70, column71, column72, column73, column74, column75, column76, column77, column78, column79, column80, column81, column82, column83, column84, column85, column86, column87, column88, column89, column90, column91, column92, column93, column94, column95, column96, column97, column98, column99, column100, column101, column102, column103, column104, column105, column106, column107, column108, column109, column110, column111)

[#2]

@Ajay R I'll be happy to help.
Can you please provide details on which tutorial you're running and section(s) that fail?
Additionally, please provide which operating system, VM and sandbox version you're running?

[#3]

@Ajay R You should revisit your statement. It clearly points out "jun13_miles" as either an invalid table or alias. Make sure you are not missing any columns in your SELECT statement based on the tutorial here

[#4]

@gdeleon I am following sandbox tutorial. Link is provided below. Created 2 tables trucks.csv, geolocation.csv successfully. I got the above error while creating table truck_mileage table. The script I have taken from the tutorial itself.

https://hortonworks.com/tutorial/hadoop-tutorial-getting-started-with-hdp/section/3/

I am using Mac (the host) 16GB RAM and allocated 8GB RAM, 2 CPU cores to Sandbox HDP 2.5 which is running on VMware fusion 10. I want to complete the HDP Sandbox tutorial End to End. But this is the first issue I faced with the Sandbox and I couldn't find the solution. Please let me know if u need any more details.

[#5]

Let's see if we can narrow down your issue:
1. What results do you get for select driverid from trucks limit 5;
You should see the following

if you get the same error, FAILED: SemanticException [Error 10004], then most likely you forgot to check first row header during the New Table -> Upload Table process:

[#6]

An updated version of Hortonworks Data Platform (HDP) 2.6.4 is available.