hi, sas data type numeric will be changed to double in hive. sas data type char will be changed to varchar in hive. i created the table in hive with partition year_month=201801 , using the data set in sas. now i am trying to append data to existing hive table with pratition year_month=201802. using proc sql insert syntax. getting errors as below like this 20 same errors i am getting , when i check fields in sas and hive shown below , pls help. 129 R50_DUNGR NUM 3 --- in sas `r50_dungr` double, --- in hive 182 R50_SIGN_ID Char 1 --- in sas `r50_sign_id` varchar(1), --- hive 183 R50_CTOPEN Num 5 --- sas `r50_ctopen` double, --- in hive ERROR: Value 182 on the SELECT clause does not match the data type of the corresponding column listed after the INSERT table name. ERROR: Value 183 on the SELECT clause does not match the data type of the corresponding column listed after the INSERT table name.
... View more