https://community.cloudera.com/t5/Support-Questions/IMPALA-scale-that-does-not-match-the-table-metadata-scale/m-p/277332#M207521 <P>1.We have hive table with below schema.</P> <P>create external table precision_1<BR />(<BR />id String,<BR />prec decimal(7,2)<BR />)<BR />partitioned by (date string)<BR />stored as parquet;</P> <P>2.insert into precision_1 partition(date='2019-02-01')&nbsp; values ('1', 2.34);</P> <P>3.insert into precision_1 partition(date='2019-02-01')&nbsp; values ('2', 3.45);</P> <P>3. 'SELECT * from precision_1' works in both impala and Hive</P> <P>4.We did following in Hive and invalidated metadata in impala:</P> <P>ALTER TABLE precision_1 CHANGE prec prec decimal(9,6);</P> <P>insert into precision_1 partition(date='2019-01-02')&nbsp; values ('1', 3.765894);</P> <P>'SELECT * from precision_1' works only in hive but not in imala</P> <P>In impala throws the below erorr.</P> <P>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)</P> <P>&nbsp;</P> <P>kindly suggest</P> <P>&nbsp;</P> Mon, 16 Sep 2019 12:46:00 GMT ravikumashi 2019-09-16T12:46:00Z