Re: Hive/Tez ORC tables -- rawDataSize value

2016-06-23 Thread Lalitha MV
Thanks for the responses Prasanth and Mich. They were helpful. @Mich: Output of desc formatted: 1. Textfile: Table Parameters: COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} numFiles1 numRows 100 rawDataSize 471

Re: Hive/Tez ORC tables -- rawDataSize value

2016-06-23 Thread Prasanth Jayachandran
Please find answers inline. On Jun 23, 2016, at 3:49 PM, Lalitha MV mailto:lalitham...@gmail.com>> wrote: Hi, I am using Hadoop 2.7.2, Tez 0.8.3 and Hive 2.0.1. I created a hive table with text file size = ~141 Mb. show tblproperties of this table (textfile): numFiles1 numRows 100

Re: Hive/Tez ORC tables -- rawDataSize value

2016-06-23 Thread Mich Talebzadeh
Hi, Can you please send the output of DESC FORMATTED after running (if you have not so already) ANALYZE TABLE COMPUTE STATISTICS FOR COLUMN For both tables? HTH, Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw