I have a table created like this successfully: CREATE TABLE IF NOT EXISTS employees (name STRING,salary FLOAT,subordinates ARRAY<STRING>,deductions MAP<STRING,FLOAT>,address STRUCT<street:STRING, city:STRING, state:STRING, zip:INT, country:STRING>)
I would like to access/display country column from my address struct. I have tried this: select address["country"] from employees; I get an error. Please help. Thanks Sai
