set parquet.column.index.acces

[#1]

Is there any way to "set parquet.column.index.access = true" as defult in hive table configuration?

the Hive version is 1.1

the cdh version is 5.14

Hope your kind suggestion.

[#2 · Accepted solution]

Resolved:

change the hive-site.xml

add

<property>
    <name>parquet.column.index.access</name>
    <value>true</value>
    <description>set parquet index access</description>
</property>

restart hive 

Done.

[#3]

For others who are using CM, you can go to CM > Hive > Configuration > Hive Service Advanced Configuration Snippet (Safety Valve) for hive-site.xml

then enter the new property name and value, save and restart Hive