John Waller jhnwllr

## gist:1a5ffee32f443f7828b01f5206b3ec7b

      
        
          
            
              
              1 file
            
          
          
            
              
              0 forks
            
          
          
            
              
              0 comments
            
          
          
            
              
              0 stars
            
          
        
        
          
              
          
          
            
                jhnwllr
                / gist:1a5ffee32f443f7828b01f5206b3ec7b
            
            
              Created
              October 19, 2018 09:54
                — forked from timrobertson100/gist:2a5a23ed0494c35317e8
            
              
                Example creating CSV file in Hue
              
          
        
      
        
  
      
    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'