1.We have hive table with below schema.
create external table precision_1 ( id String, prec decimal(7,2) ) partitioned by (date string) stored as parquet;
2.insert into precision_1 partition(date='2019-02-01') values ('1', 2.34);
3.insert into precision_1 partition(date='2019-02-01') values ('2', 3.45);
3. 'SELECT * from precision_1' works in both impala and Hive
4.We did following in Hive and invalidated metadata in impala:
ALTER TABLE precision_1 CHANGE prec prec decimal(9,6);
insert into precision_1 partition(date='2019-01-02') values ('1', 3.765894);
'SELECT * from precision_1' works only in hive but not in imala
In impala throws the below erorr.
Bad status for request TFetchResultsReq(fetchType=0, operationHandle=TOperationHandle(hasResultSet=True, modifiedRowCount=None, operationType=0, operationId=THandleIdentifier(secret='pq)"\xf9LNN\x00\x00\x00\x00\xb1Z\x17{', guid='pq)"\xf9LNN\x00\x00\x00\x00\xb1Z\x17{')), orientation=4, maxRows=100): TFetchResultsResp(status=TStatus(errorCode=None, errorMessage="File 'hdfs://devana1/user/hive/warehouse/precision_1/date=2019-02-01/000000_0_copy_1' column 'prec' has a scale that does not match the table metadata scale. File metadata scale: 2 Table metadata scale: 6\n", sqlState='HY000', infoMessages=None, statusCode=3), results=None, hasMoreRows=None)
kindly suggest
... View more
