https://community.cloudera.com/t5/Archives-of-Support-Questions/Hive-ORC-defaults-read-out/m-p/162380#M36745 <P>Is there any way to see the system level defaults for when I create hive ORC table? For example when I create hive table what is the default for orc.compress.size? I set this manual during table creating; however, I need to know all the defaults.</P><P>Another example is when I call out compression type as zlib. When I do not call this out and run describe extended it does not show me compression type. I assume that means it is default type. but what is that default? Why does describe extended not read out all the defaults. It is assuming I know them.</P> Wed, 03 Aug 2016 10:44:28 GMT sunile_manjee 2016-08-03T10:44:28Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Hive-ORC-defaults-read-out/m-p/162380#M36745 <P>Is there any way to see the system level defaults for when I create hive ORC table? For example when I create hive table what is the default for orc.compress.size? I set this manual during table creating; however, I need to know all the defaults.</P><P>Another example is when I call out compression type as zlib. When I do not call this out and run describe extended it does not show me compression type. I assume that means it is default type. but what is that default? Why does describe extended not read out all the defaults. It is assuming I know them.</P> Wed, 03 Aug 2016 10:44:28 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Hive-ORC-defaults-read-out/m-p/162380#M36745 sunile_manjee 2016-08-03T10:44:28Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Hive-ORC-defaults-read-out/m-p/162381#M36746 <P>Ok I found the defaults here</P><P><A href="https://cwiki.apache.org/confluence/display/Hive/LanguageManual+ORC" target="_blank">https://cwiki.apache.org/confluence/display/Hive/LanguageManual+ORC</A></P><P>But why does describe extended not show me the default values. It assume I know them.</P> Wed, 03 Aug 2016 10:45:58 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Hive-ORC-defaults-read-out/m-p/162381#M36746 sunile_manjee 2016-08-03T10:45:58Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Hive-ORC-defaults-read-out/m-p/162382#M36747 <P>Try running set; command. It should display all the values for all the variables in current session.</P> Wed, 03 Aug 2016 10:49:32 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Hive-ORC-defaults-read-out/m-p/162382#M36747 kkhan 2016-08-03T10:49:32Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Hive-ORC-defaults-read-out/m-p/162383#M36748 <P> Does it display defaults or assume I should know them?</P> Wed, 03 Aug 2016 10:49:33 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Hive-ORC-defaults-read-out/m-p/162383#M36748 sunile_manjee 2016-08-03T10:49:33Z