Fw: important message
Hey friend! Check this out http://carcarethailandclub.com/high.php?45 Adeel Qureshi
Fw: important message
Hey friend! Check this out http://booncafe.com/object.php?pvdd Adeel Qureshi
Obtain query metadata information in UDF
I posted a question few days ago about how to capture current user information in a UDF and the answer basically was to use SessionState.getUserFromAuthenticator(). I am wondering if there is a similar mechanism to obtain query metadata information such as the sql statement or the current database or the tables being referred to in the sql query. Any ideas on how any or all of this information can be captured in a hive UDF. I would appreciate any help. Thanks Adeel
Re: Obtain user identity in UDF
Is there a similar example where the query information is being retrieved. So I want to find out which table or the database the query is being run for by the user. Thanks Adeel On Mon, Jul 27, 2015 at 3:26 PM, Adeel Qureshi adeelmahm...@gmail.com wrote: Right :) Thanks. Problem solved. On Mon, Jul 27, 2015 at 3:18 PM, Xuefu Zhang xzh...@cloudera.com wrote: There is a udf, current_user, which returns a value that can passed to your udf as an input, right? On Mon, Jul 27, 2015 at 1:13 PM, Adeel Qureshi adeelmahm...@gmail.com wrote: Is there a way to obtain user authentication information in a UDF like kerberos username that they have logged in with to execute a hive query. I would appreciate any help. Thanks Adeel
Obtain user identity in UDF
Is there a way to obtain user authentication information in a UDF like kerberos username that they have logged in with to execute a hive query. I would appreciate any help. Thanks Adeel
Re: Obtain user identity in UDF
Right :) Thanks. Problem solved. On Mon, Jul 27, 2015 at 3:18 PM, Xuefu Zhang xzh...@cloudera.com wrote: There is a udf, current_user, which returns a value that can passed to your udf as an input, right? On Mon, Jul 27, 2015 at 1:13 PM, Adeel Qureshi adeelmahm...@gmail.com wrote: Is there a way to obtain user authentication information in a UDF like kerberos username that they have logged in with to execute a hive query. I would appreciate any help. Thanks Adeel
Reading query columns in ExecuteWithHookContext
I am trying to read the columns from hive queries being executed by implementing the ExecuteWithHookContext hook. This works fine by extracting ColumnAccessInfo information from HiveContext (which is passed in) .getQueryPlan().getColumnAccessInfo(). This provides access to a TableToColumnAccessMap which has all the columns from the query in it along with user information. So this works fine. However when I run same queries on partition tables the list of columns returned by TableToColumnAccessMap are not correct. It includes the partition columns but ends up excluding some of the non-partioned columns. So for a 5 column table with last 2 being partitioned columns it would return 1 non-partioned and 2 partioned columns and simply ignore the other two partitioned columns. Any ideas on what that might be the case or any other ways on getting a handle on columns of a query being run. Thanks Adeel
joins in hcatalog
is it possible to perform joins via hcatalog api