How to identify delimiters in case not mentioned in Hive table description

No details for the delimiters in this command:
If not mentioned, should we always consider it as ‘\001’ ?

hive> describe formatted products_hive;

col_name data_type comment

product_id int
product_category_id int
product_name string
product_description string
product_price float
product_imaage string
product_grade int
product_sentiment string

Detailed Table Information

Database: default
Owner: cloudera
CreateTime: Sun Jun 25 09:06:50 PDT 2017
LastAccessTime: UNKNOWN
Protect Mode: None
Retention: 0
Location: hdfs://quickstart.cloudera:8020/user/hive/warehouse/products_hive
Table Parameters:
numFiles 6
totalSize 187490
transient_lastDdlTime 1498407500

Storage Information

SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
InputFormat: org.apache.hadoop.mapred.TextInputFormat
Compressed: No
Num Buckets: -1
Bucket Columns: []
Sort Columns: []
Storage Desc Params:
serialization.format 1

@nitesh i think u can try this show create table tablename;

1 Like

Yes you are correct, if no delimiter specified in describe command then it is default one i.e. \001 (null character) as you mentioned.

1 Like

Thanks @N_Chakote @Rahul