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

Reply via email to