HADOOP_8: Executed: on connection 2 LOAD DATA INPATH '/tmp/sastmp/sasdata-2019-04-04-16-30-00-841-e-00001.dlv' OVERWRITE INTO TABLE sastmp_04_04_16_30_02_424_00002 HADOOP_9: Executed: on connection 2 set hive.exec.dynamic.partition.mode=nonstrict HADOOP_10: Executed: on connection 2 set hive.exec.dynamic.partition=true HADOOP_11: Executed: on connection 2 set mapred.max.split.size=536870912 HADOOP_12: Executed: on connection 2 INSERT INTO TABLE `cars_temp` SELECT * FROM sastmp_04_04_16_30_02_424_00002 HADOOP_13: Executed: on connection 2 DROP TABLE sastmp_04_04_16_30_02_424_00002 ERROR: Execute error: ERROR: The INSERT INTO table cars_temp from table sastmp_04_04_16_30_02_424_00002 failed. NOTE: SAS set option OBS=0 and will continue to check statements. This might cause NOTE: No observations in data set. NOTE: DATA statement used (Total process time): real time 8.21 seconds cpu time 0.51 seconds 28 29 Extra Information : ********************* Actual table cars_temp table is getting created with zero records. ERROR: The INSERT INTO table cars_temp from table sastmp_04_04_16_30_02_424_00002 failed. I checked all the folder permissions(777), everything looks good. Recently upgraded to HDP3.1.0.
... View more