Example creating CSV file in Hue

gistfile1.md

Step 1: Create a table as CSV

CREATE EXTERNAL TABLE tim.delimiter_csv (
  gbifId INT,
  v_scientificName STRING  
)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
STORED AS TEXTFILE LOCATION '/user/tim/delimiter.csv'

Step 2: Populate the table

1. add the jar (/user/trobertson/occurrence-hive-0.22-SNAPSHOT-jar-with-dependencies.jar)
2. create the UDF (cleanDelimiters and org.gbif.occurrence.hive.udf.CleanDelimiterCharsUDF)
3. run the SQL:

INSERT OVERWRITE TABLE tim.delimiter_csv
SELECT 
  gbifId, 
  cleanDelimiters(v_scientificName)
FROM prod_b.occurrence_hdfs
LIMIT 1000000