Choose the best query to run in Impala to return the distinct union of the columns zip_plus_4 (type STRING, has values like ‘94306-0001’) in the california_emp table and zip (type INT, has values like 94105) in the california_offices table.
Question 3
Choose the best query to run in Impala to return the distinct union of the columns zip_plus_4 (type STRING, has values like ‘94306-0001’) in the california_emp table and zip (type INT, has values like 94105) in the california_offices table.
1 point
- SELECT zip_plus_4 FROM california_emp UNION DISTINCT SELECT CAST(zip AS STRING) FROM california_offices;
- SELECT zip_plus_4 AS zipcode FROM california_emp UNION DISTINCT SELECT zip AS zipcode FROM california_offices;
- SELECT zip_plus_4 FROM california_emp UNION DISTINCT SELECT zip FROM california_offices;
- SELECT zip_plus_4 AS zipcode FROM california_emp UNION DISTINCT SELECT CAST(zip AS STRING) AS zipcode FROM california_offices;
- SELECT CAST(zip_plus_4 AS INT) AS zipcode FROM california_emp UNION DISTINCT SELECT zip AS zipcode FROM california_offices;