Member since
02-22-2018
2
Posts
0
Kudos Received
0
Solutions
02-22-2018
11:41 PM
@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.
... View more
02-22-2018
01:26 PM
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)
... View more
Labels:
- Labels:
-
Apache Ambari
-
Apache Hive