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.
Thanks
Sai
