Reply
Expert Contributor
Posts: 139
Registered: ‎07-21-2014

Querying using HiveQL's Matchpath

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.*?

 

Thanks!

New Contributor
Posts: 2
Registered: ‎04-16-2015

Re: Querying using HiveQL's Matchpath

[ Edited ]

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.

Cloudera Employee
Posts: 120
Registered: ‎11-20-2015
New Contributor
Posts: 2
Registered: ‎04-16-2015

Re: Querying using HiveQL's Matchpath

Thanks David,

 

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