Hi @jAnshula I created the table as parquet. However, I am still getting issue after insert data. Here is my query to create the table and insert to the table: CREATE TABLE ATABLE ( CHARCOL CHAR(10), VCHARCOL VARCHAR(10), DECIMALCOL DECIMAL(15,5), NUMERICCOL DOUBLE, SMALLCOL SMALLINT, INTEGERCOL INT, REALCOL FLOAT, FLOATCOL FLOAT, DOUBLECOL DOUBLE, LVCOL STRING, BITCOL BOOLEAN, TINYINTCOL TINYINT, BIGINTCOL BIGINT, BINCOL STRING, VARBINCOL STRING, LVARBINCOL STRING, DATECOL STRING, TIMECOL STRING, TSCOL TIMESTAMP ) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS PARQUET; Then insert data to the table: INSERT OVERWRITE TABLE ATABLE SELECT * FROM JMASTER.ATABLE and the result: Query: INSERT OVERWRITE TABLE ATABLE SELECT * FROM JMASTER.ATABLE Query submitted at: 2024-02-16 09:03:11 (Coordinator: http://hiveservername.domainame.com:25000) Query progress can be monitored at: http://hiveservername.domainame.com:25000/query_plan?query_id=7042592eded60891:ee0cba7600000000 ERROR: File 'hdfs://hiveservername.domainame.com:8020/user/hivetest/master_tables/hivetesttable/ATABLE.csv' has an invalid Parquet version number: 30 30 30 30 . Please check that it is a valid Parquet file. This error can also occur due to stale metadata. If you believe this is a valid Parquet file, try running "refresh jmaster.hivetesttable".
... View more
