Support Questions
Find answers, ask questions, and share your expertise
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Querying using HiveQL's Matchpath

Querying using HiveQL's Matchpath

Expert Contributor

While looking at the options to generate the funnel reports, I came across Matchpath UDF. Are there any usage examples and can anyone confirm if its available in CDH 5.3.*?




Re: Querying using HiveQL's Matchpath

New Contributor

Hi, I'm facing the same issue on CDH 5.4.


Did you find any information of the function usage?


The java class is on the hive sources and a describe function matchpath query returns the following:


"There is no documentation for function 'matchpath'"


So it must be available.


Thing is I'm not capable of writing a working query with this function.

Re: Querying using HiveQL's Matchpath

New Contributor

Thanks David,


That's something to start with, at least this allows me to execute a simple query. 


Don't have an account?
Coming from Hortonworks? Activate your account here