Page History

...

This can be configured on a per client basis by using the "set metaconf:hive.metastore.try.direct.sql.ddl=<value>" command, starting with Hive 0.14.0 (HIVE-7532).

hive.direct.sql.max.query.length

• Default Value: 100
• Added In: Hive 1.3.0 and 2.1.0 (but not 2.0.x) with HIVE-12349

The maximum size of a query string (in KB) as generated by direct SQL.

hive.direct.sql.max.elements.in.clause

• Default Value: 1000
• Added In: Hive 1.3.0 and 2.1.0 (but not 2.0.x) with HIVE-12349

The maximum number of values in a IN clause as generated by direct SQL. Once exceeded, it will be broken into multiple OR separated IN clauses.

hive.direct.sql.max.elements.values.clause

• Default Value: 1000
• Added In: Hive 1.3.0 and 2.1.0 (but not 2.0.x) with HIVE-12349

The maximum number of values in a VALUES clause for an INSERT statement as generated by direct SQL.

hive.metastore.port

• Default Value: 9083
• Added In: Hive 1.3.0 with HIVE-9365

...

For WebHCat configuration, see Configuration Variables in the WebHCat manual.