Advertisement
Guest User

Untitled

a guest
Feb 10th, 2016
50
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.51 KB | None | 0 0
  1. drop table if exists Insurance;
  2. create external table Insurance(age STRING, sex STRING, bmi STRING, children STRING, smoker STRING, region STRING, charges STRING)
  3. row format delimited
  4. fields terminated by ','
  5. stored as textfile location 'wasb://jdXX@sXX01.blob.core.windows.net/insurance.csv’;
  6.  
  7. H110 Unable to submit statement. Error while compiling statement: FAILED: ParseException line 5:29 mismatched input 'wasb' expecting StringLiteral near 'location' in table location specification [ERROR_STATUS]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement