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 >
