Steps to Reproduce
The following schema represent a table that suffers from this problem:
CREATE TABLE Statistics10Min(WindFarm STRING,WTG STRING, LocalTS STRING, TS STRING,WindSpeedAvg FLOAT,WindSpeedMin FLOAT,WindSpeedMax FLOAT,WindSpeedStdDev FLOAT,ActPowAvg FLOAT,ActPowMin FLOAT,ActPowMax FLOAT,ActPowStdDev FLOAT,ReactPowAvg FLOAT,ReactPowMin FLOAT,ReactPowMax FLOAT,ReactPowStdDev FLOAT,GenSpeedAvg FLOAT,GenSpeedMin FLOAT,GenSpeedMax FLOAT,GenSpeedStdDev FLOAT,RotSpeedAvg FLOAT,RotSpeedMin FLOAT,RotSpeedMax FLOAT,RotSpeedStdDev FLOAT,YawDirAvg FLOAT,YawDirMin FLOAT,YawDirMax FLOAT,YawDirStdDev FLOAT,VibTowAvg FLOAT,VibTowMin FLOAT,VibTowMax FLOAT,VibTowStdDev FLOAT,PitchAvg FLOAT,PitchMin FLOAT,PitchMax FLOAT,PitchRateMin FLOAT,PitchRateMax FLOAT,PitchRateStdDev FLOAT,GridVoltAvg FLOAT,GridVoltMin FLOAT,GridVoltMax FLOAT,EnvTempAvg FLOAT,EnvTempMin FLOAT,EnvTempMax FLOAT,GbxTempAvg FLOAT,GbxTempMin FLOAT,GbxTempMax FLOAT,GenAccMin FLOAT,GenAccMax FLOAT,VibratAvg FLOAT,VibratMax FLOAT,GenU1TempAvg FLOAT,GenU1TempMin FLOAT,GenU1TempMax FLOAT,RotorSideLTempAvg FLOAT,RotorSideLTempMin FLOAT,RotorSideLTempMax FLOAT,WindBin FLOAT,FreqMean FLOAT) ROW FORMAT DELIMITED FIELDS TERMINATED BY '59' LINES TERMINATED BY '10';
Then, the actual data is loaded, such as:
LOAD DATA INPATH '/user/test/staging/statistics/out/part-00000' INTO TABLE Statistics10Min
The input data are CSV sequence files.