Github user gatorsmile commented on the issue:
https://github.com/apache/spark/pull/14638
In the Hive document, this is not included.
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-CreateTable
The list does not include it:
```
TBLPROPERTIES ("comment"="table_comment")
TBLPROPERTIES ("hbase.table.name"="table_name") â see HBase Integration.
TBLPROPERTIES ("immutable"="true") or ("immutable"="false") in release
0.13.0+ (HIVE-6406) â see Inserting Data into Hive Tables from Queries.
TBLPROPERTIES ("orc.compress"="ZLIB") or ("orc.compress"="SNAPPY") or
("orc.compress"="NONE") and other ORC properties â see ORC Files.
TBLPROPERTIES ("transactional"="true") or ("transactional"="false") in
release 0.14.0+, the default is "false" â see Hive Transactions.
TBLPROPERTIES ("NO_AUTO_COMPACTION"="true") or
("NO_AUTO_COMPACTION"="false"), the default is "false" â see Hive
Transactions.
TBLPROPERTIES ("compactor.mapreduce.map.memory.mb"="mapper_memory") â see
Hive Transactions.
TBLPROPERTIES
("compactorthreshold.hive.compactor.delta.num.threshold"="threshold_num") â
see Hive Transactions.
TBLPROPERTIES
("compactorthreshold.hive.compactor.delta.pct.threshold"="threshold_pct") â
see Hive Transactions.
TBLPROPERTIES ("auto.purge"="true") or ("auto.purge"="false") in release
1.2.0+ (HIVE-9118) â see Drop Table and Drop Partitions.
TBLPROPERTIES ("EXTERNAL"="TRUE") in release 0.6.0+ (HIVE-1329) â Change
a managed table to an external table and vice versa for "FALSE".
```
More importantly, we have not officially allowed users to use TBLPROPERTIES
in Spark. I do not know whether this is the right way to do it. cc @rxin
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
