Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- drop table if exists Insurance;
- create external table Insurance(age STRING, sex STRING, bmi STRING, children STRING, smoker STRING, region STRING, charges STRING)
- row format delimited
- fields terminated by ','
- stored as textfile location 'wasb://jdXX@sXX01.blob.core.windows.net/insurance.csv’;
- 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