Hi, I am following https://hortonworks.com/tutorial/how-to-process-data-with-apache-hive/ using Hive View 2.0. I copied the exact query, running on Virtual Box (see the query commend below); however, the query keeps hanging. Anyone else has the same issue? insert overwrite table drivers SELECT regexp_extract(col_value,'^(?:([^,]*),?){1}',1) driverId, regexp_extract(col_value,'^(?:([^,]*),?){2}',1) name, regexp_extract(col_value,'^(?:([^,]*),?){3}',1) ssn, regexp_extract(col_value,'^(?:([^,]*),?){4}',1) location, regexp_extract(col_value,'^(?:([^,]*),?){5}',1) certified, regexp_extract(col_value,'^(?:([^,]*),?){6}',1) wageplan from temp_drivers; ... View more

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? ... View more