0

I created the table below with ';' delimiter, but in the column 'value' it only appears numbers without 'comma', numbers with comma doesn't appear.

CREATE EXTERNAL TABLE `table` (
  `value` double,
ROW FORMAT DELIMITED 
  FIELDS TERMINATED BY '\;' 
STORED AS INPUTFORMAT 
  'org.apache.hadoop.mapred.TextInputFormat' 
OUTPUTFORMAT 
  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'

Inside CSV: | output:
  value        value
    24          24.0
    24,96       

Expect:
Inside CSV: | output:
  value        value
    24          24.0
    24,96       24.96
William Soares
  • 33
  • 4
  • had this issue when working with french localization, seperator was considered comma, maybe similar to https://stackoverflow.com/questions/41246004/how-to-handle-comma-separated-decimal-values-in-hive – Anass Kartit Dec 07 '22 at 21:10
  • Consider using pipe '|' as delimiter. – Guy Dec 09 '22 at 00:12

0 Answers0