question Using Pig to Load Data into ORC in Archives of Support Questions (Read Only) https://community.cloudera.com/t5/Archives-of-Support-Questions/Using-Pig-to-Load-Data-into-ORC/m-p/120401#M30732 <P>I have a script that loads data into an ORC table, seems I can only load TEXT data type. Are other data types supported?</P><P>Or is there a better way to load bulk CSV data and load into ORC tables.</P><P>Thanks.</P> Sat, 04 Jun 2016 04:09:25 GMT TimothySpann 2016-06-04T04:09:25Z Using Pig to Load Data into ORC https://community.cloudera.com/t5/Archives-of-Support-Questions/Using-Pig-to-Load-Data-into-ORC/m-p/120401#M30732 <P>I have a script that loads data into an ORC table, seems I can only load TEXT data type. Are other data types supported?</P><P>Or is there a better way to load bulk CSV data and load into ORC tables.</P><P>Thanks.</P> Sat, 04 Jun 2016 04:09:25 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Using-Pig-to-Load-Data-into-ORC/m-p/120401#M30732 TimothySpann 2016-06-04T04:09:25Z Re: Using Pig to Load Data into ORC https://community.cloudera.com/t5/Archives-of-Support-Questions/Using-Pig-to-Load-Data-into-ORC/m-p/120402#M30733 <A rel="user" href="https://community.cloudera.com/users/9304/tspann.html" nodeid="9304">@Timothy Spann</A><P>You can also use pig ORC storage and store file in ORC, afterward create external hive table and point it to orc directory.</P><P><A href="https://pig.apache.org/docs/r0.15.0/func.html#OrcStorage" target="_blank">https://pig.apache.org/docs/r0.15.0/func.html#OrcStorage</A></P><H4>Data types</H4><P>Most Orc data type has one to one mapping to Pig data type. Several exceptions are:</P><P>Loader side:</P><UL> <LI>Orc STRING/CHAR/VARCHAR all map to Pig varchar</LI><LI>Orc BYTE/BINARY all map to Pig bytearray</LI><LI>Orc TIMESTAMP/DATE all maps to Pig datetime</LI><LI>Orc DECIMAL maps to Pig bigdecimal</LI></UL><P>Storer side:</P><UL> <LI>Pig chararray maps to Orc STRING</LI><LI>Pig datetime maps to Orc TIMESTAMP</LI><LI>Pig bigdecimal/biginteger all map to Orc DECIMAL</LI><LI>Pig bytearray maps to Orc BINARY</LI></UL> Sat, 04 Jun 2016 04:39:53 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Using-Pig-to-Load-Data-into-ORC/m-p/120402#M30733 jyadav 2016-06-04T04:39:53Z