Support Questions

Find answers, ask questions, and share your expertise

Hive ORC defaults read out

avatar
Master Guru

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.

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.

1 ACCEPTED SOLUTION

avatar
Master Guru

Ok I found the defaults here

https://cwiki.apache.org/confluence/display/Hive/LanguageManual+ORC

But why does describe extended not show me the default values. It assume I know them.

View solution in original post

3 REPLIES 3

avatar
Master Guru

Ok I found the defaults here

https://cwiki.apache.org/confluence/display/Hive/LanguageManual+ORC

But why does describe extended not show me the default values. It assume I know them.

avatar
Expert Contributor

Try running set; command. It should display all the values for all the variables in current session.

avatar
Master Guru

Does it display defaults or assume I should know them?