[ 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)