yes right can you give me a tip how to exclude blank values On Tue, Mar 9, 2010 at 2:13 PM, Zheng Shao <[email protected]> wrote:
> So I guess you didn't exclude the Blank ones? > > On Tue, Mar 9, 2010 at 12:41 AM, prakash sejwani > <[email protected]> wrote: > > yes, regexp_extract return NULL or Blank > > > > On Tue, Mar 9, 2010 at 2:05 PM, Zheng Shao <[email protected]> wrote: > >> > >> What do you mean by "product_name" is "present"? > >> If it is not present, does the regexp_extract return NULL? > >> > >> Zheng > >> > >> On Tue, Mar 9, 2010 at 12:13 AM, prakash sejwani > >> <[email protected]> wrote: > >> > Hi all, > >> > I have a query below > >> > > >> > FROM ( > >> > SELECT h.* > >> > FROM ( > >> > -- Pull from the access_log > >> > SELECT ip, > >> > -- Reformat the time from the access log > >> > time, dt, > >> > --method, resource, protocol, status, length, referer, agent, > >> > -- Extract the product_id for the hit from the URL > >> > cast( regexp_extract(resource,'\&q=([^\&]+)', 1) AS STRING) AS > >> > product_name > >> > FROM a_log > >> > ) h > >> > )hit > >> > -- Insert the hit data into a seperate search table > >> > INSERT OVERWRITE TABLE search > >> > SELECT ip, time, dt, > >> > product_name > >> > WHERE product_name IS NOT NULL; > >> > > >> > > >> > it suppose to populate the search table with only if product_name is > >> > present > >> > but i get all of it.. > >> > > >> > any help would be appreciated > >> > > >> > thanks > >> > prakash sejwani > >> > econify infotech > >> > mumbai > >> > > >> > >> > >> > >> -- > >> Yours, > >> Zheng > > > > > > > > -- > Yours, > Zheng >
