question Re: invalid type length for Decimal fields when Impala query on Parquet stored Hive Table in Support Questions

question Re: invalid type length for Decimal fields when Impala query on Parquet stored Hive Table in Support Questions https://community.cloudera.com/t5/Support-Questions/invalid-type-length-for-Decimal-fields-when-Impala-query-on/m-p/289719#M214419 Hi Iwang, Thank you for your response. I tried with <PRE>TBLPROPERTIES ('OBJCAPABILITIES'='EXTREAD,EXTWRITE</PRE>hive table properties for creating table.But, as Yongzhi  stated that it is not solution for the fixed-length type.My hive table creation script is;CREATE TABLE ods.kds_limit_log(ONERILENLIMITADI STRING,PROPOSEDCOLLATERALTYPE STRING,ONERILENMAXVADE STRING,ONERILENDOVIZ STRING,KDSREFORDER DECIMAL(3,0),LASTUPDATED DECIMAL(15,0),ONERILENMORTGAGELIMITTUTARI DECIMAL(25,2),OID DECIMAL(16,0),ONERILENKGFLIMITTUTARI DECIMAL(25,2),MEVCUTMAXVADE STRING,STATUS DECIMAL(1,0),MEVCUTLIMITTUTARI DECIMAL(25,2),ENTERANCEDATE DECIMAL(8,0),ONERILENLIMITTUTARI DECIMAL(25,2),MEVCUTDOVIZ STRING,MEVCUTRISKTUTARI DECIMAL(25,2),ONERILENLIMITREFERANS STRING,ENTERANCETIME DECIMAL(6,0),MEVCUTLIMITADI STRING,EXISTINGCOLLATERALTYPE STRING,ONERILENEASILIMITTUTARI DECIMAL(25,2),KDSREFNO STRING,MEVCUTLIMITREFERANS STRING) STORED AS PARQUET LOCATION '/data/ods.db/kds_limit_log/' TBLPROPERTIES ('OBJCAPABILITIES'='EXTREAD,EXTWRITE') Parquet file schema; <img src="https://community.cloudera.com/t5/image/serverpage/image-id/26365i5F0E8783CB88C051/image-size/large?v=v2&px=999" role="button" title="Capture4.JPG" alt="Capture4.JPG" />It can be run with Hive, but not with Impala <img src="https://community.cloudera.com/t5/image/serverpage/image-id/26366i50E6F5E368615CA9/image-size/large?v=v2&px=999" role="button" title="Capture3.JPG" alt="Capture3.JPG" /> Best regardsOnur Thu, 13 Feb 2020 12:53:41 GMT Onur 2020-02-13T12:53:41Z