question Re: Is it possible to convert a text file format to ORC file format not the table? Also when I'm trying to insert into ORC table from a text file table, the data is not inserting even though mapreduce job is happening. Please help me in this regard in Support Questions https://community.cloudera.com/t5/Support-Questions/Is-it-possible-to-convert-a-text-file-format-to-ORC-file/m-p/168593#M130923 <P>Hi <A rel="user" href="https://community.cloudera.com/users/12361/pmayank02.html" nodeid="12361">@Mayank Pandey</A></P><P>If you have existing tables (not in ORC format), I'd recommend creating the ORC tables. Then run:</P><PRE>insert into yourorctable select * from yourexistingtable;</PRE><P>Is this how you are currently inserting data?</P> Mon, 08 Aug 2016 22:13:36 GMT RyanCicak 2016-08-08T22:13:36Z Is it possible to convert a text file format to ORC file format not the table? Also when I'm trying to insert into ORC table from a text file table, the data is not inserting even though mapreduce job is happening. Please help me in this regard https://community.cloudera.com/t5/Support-Questions/Is-it-possible-to-convert-a-text-file-format-to-ORC-file/m-p/168592#M130922 Fri, 16 Sep 2022 10:33:18 GMT https://community.cloudera.com/t5/Support-Questions/Is-it-possible-to-convert-a-text-file-format-to-ORC-file/m-p/168592#M130922 pmayank02 2022-09-16T10:33:18Z Re: Is it possible to convert a text file format to ORC file format not the table? Also when I'm trying to insert into ORC table from a text file table, the data is not inserting even though mapreduce job is happening. Please help me in this regard https://community.cloudera.com/t5/Support-Questions/Is-it-possible-to-convert-a-text-file-format-to-ORC-file/m-p/168593#M130923 <P>Hi <A rel="user" href="https://community.cloudera.com/users/12361/pmayank02.html" nodeid="12361">@Mayank Pandey</A></P><P>If you have existing tables (not in ORC format), I'd recommend creating the ORC tables. Then run:</P><PRE>insert into yourorctable select * from yourexistingtable;</PRE><P>Is this how you are currently inserting data?</P> Mon, 08 Aug 2016 22:13:36 GMT https://community.cloudera.com/t5/Support-Questions/Is-it-possible-to-convert-a-text-file-format-to-ORC-file/m-p/168593#M130923 RyanCicak 2016-08-08T22:13:36Z