Hive Configuration

Hive SQL parameters are used to customize rules for Hive SQL script migration.

Open the features-hive.properties file in the config folder and set parameters in Table 1 as required.

**Table 1** Parameters in the features-hive.properties file
Parameter	Description	Value Range	Default Value	Example
table.orientation	Row- and column-store parameter. By default, this parameter is not specified.	COLUMN ROW Null	Null	table.orientation=
table.distribute-key.choose.strategy	Policy for selecting the distribution key. The value can be ROUNDROBIN, HASH, or REPLICATION.	ROUNDROBIN HASH REPLICATION Null	Null	table.distribute-key.choose.strategy=
table.function.current_date	Whether to convert a data value to the value of the current_date parameter. By default, the date value is not converted.	true false	false	table.function.current_date=false
table.function.unix_timestamp	Whether to add a to_timestamp nesting layer to unix_timestamp. By default, it is not added.	true false	false	table.function.unix_timestamp=false
table.option.doubleQuoteForAs	Whether to remove or add double quotation marks for the AS alias. ori (default value): The AS alias remains unchanged. remove: Double quotation marks are removed. add: Double quotation marks are added.	ori remove add	ori	table.option.doubleQuoteForAs=ori
table.option.joinOn	Mode for controlling the JOIN operation. true: ON 1=1 is automatically added, and a Cartesian JOIN is forcibly used. false (default value): The JOIN condition must be specified.	true false	false	table.option.joinOn=false
table.enable.hstore	Whether to allow HStore tables.	true false	false	table.enable.hstore=false
table.enable.hstore.opt	Whether to allow HStore Opt operations.	true false	false	table.enable.hstore.opt=false
table.column.addQuote	Whether to remove double quotation marks from the query column and add single quotation marks.	true false	false	table.column.addQuote=false
table.special.add.primary.key	Whether to add a primary key to the column whose name is id or tableName_id. The default value is false, indicating that the primary key is not added. The value true indicates that the primary key is added.	true false	false	table.special.add.primary.key=false