[
https://issues.apache.org/jira/browse/HIVE-22575?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16987531#comment-16987531
]
Rajkumar Singh commented on HIVE-22575:
---------------------------------------
starting hive-3, by default managed tables are acid and stored as ORC, I
believe the property to control default managed storage is
hive.default.fileformat.managed.
> "set hive.default.fileformat = TextFile" ,modifying the configuration
> parameters does not work
> ----------------------------------------------------------------------------------------------
>
> Key: HIVE-22575
> URL: https://issues.apache.org/jira/browse/HIVE-22575
> Project: Hive
> Issue Type: Bug
> Affects Versions: 3.1.1
> Reporter: lv haiyang
> Priority: Major
>
> 0: jdbc:hive2://master:2181,sdw1:2181,sdw2:21> set hive.default.fileformat;
> +-----------------------------------+
> | set |
> +-----------------------------------+
> | hive.default.fileformat=TextFile |
> +-----------------------------------+
> 1 row selected (0.024 seconds)
> 0: jdbc:hive2://master:2181,sdw1:2181,sdw2:21> create textfile_table(id
> int,desc string);
> 0: jdbc:hive2://master:2181,sdw1:2181,sdw2:21> desc formatted textfile_table;
> INFO : OK
> +-------------------------------+----------------------------------------------------+----------------------------------------------------+
> | col_name | data_type
> | comment |
> +-------------------------------+----------------------------------------------------+----------------------------------------------------+
> | id | int
> | |
> | desc | string
> | |
> | # Storage Information | NULL
> | NULL |
> | SerDe Library: | org.apache.hadoop.hive.ql.io.orc.OrcSerde
> | NULL |
> | InputFormat: |
> org.apache.hadoop.hive.ql.io.orc.OrcInputFormat | NULL
> |
> | OutputFormat: |
> org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat | NULL
> |
> | Compressed: | No
> | NULL |
> | Num Buckets: | -1
> | NULL |
> | Bucket Columns: | []
> | NULL |
> | Sort Columns: | []
> | NULL |
> | Storage Desc Params: | NULL
> | NULL |
> | | serialization.format
> | 1 |
> +-------------------------------+----------------------------------------------------+----------------------------------------------------+
--
This message was sent by Atlassian Jira
(v8.3.4#803005)