hive> describe spect;
describe spect;
OK
url string
key string
crawler
struct<domain:string,component:string,http_headers:string,machine:string,proxy:string,crawl_time:bigint>
dust struct<in_the_system:boolean,urls:array<string>>
Time taken: 0.046 seconds
hive>select crawler.domain from spect;
OK
domain
domain2
domain3
domain4
domain5
domain
domain2
domain3
domain4
domain5
domain_failed
Time taken: 17.183 seconds
HOWEVER, now when I try to fire the query where crawler.domain , I get blank
answer , no records.
hive>select crawler.domain , dust.in_the_system from spect where crawler.domain
like '%1';
OK
Time taken: 5.442 seconds
hive>select crawler.domain , dust.in_the_system from specttacles where
crawler.domain ='domain1';
OK
Time taken: 5.457 seconds
hive>
pl help. How can I query fields in struct ?
OR wht I am doing wrong here
-Sagar
