Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Re: Read map value from a table

Copy link to this message
Re: Read map value from a table
Here is my data in a file which i have successfully loaded into a table test and successfully get the data for:

Select * from test;

Name    ph        category
Name1    ph1    {"type":1000,"color":200,"shape":610}
Name2    ph2    {"type":2000,"color":200,"shape":150}
Name3    ph3    {"type":3000,"color":700,"shape":167}

But when i execute this query:

select category["type"] from test;

I get null values;

Please help.