Hi guys, The question is looking very simple.But i don't why i unable to get the solution.Think like we emp table similar to scott schema(oracle).I just want to write a query whose hiredate is more that hiredate of employee KING. Here is the Query: select ename,hiredate from emp e1 where e1.hiredate > (select hiredate from emp e2 where e2.ename='KING') But unfortunately we have only support for 'IN' (Subqueries) in hive.How to achieve the requirement. ... View more

Hi guys, I know hive is Data Warehousing tool which is not suited as OLTP. In regular RDBMS Structure i have way like "Correlated queries" helps to find nth highest salary from a table as following. Is there any way in hive also.The query is related to true/false conditions. SELECT * /*This is the outer query part */ FROM Employee Emp1 WHERE (N-1) = ( /* Subquery starts here */ SELECT COUNT(DISTINCT(Emp2.Salary)) FROM Employee Emp2 WHERE Emp2.Salary > Emp1.Salary) ... View more

I have seen URLDecoder as an example for Pig Dynamic Invokers. Can i have more examples like String related functions or may be other that pig use as dynamic invokers? ... View more

I would like to select one normal datatype column(primitive) column along with UDTF as follows.But it is throwing error like SemanticException [Error 10081]: UDTF's are not supported outside the SELECT clause, nor nested in expressions I understood the problem.Don't we have any way to do this. Query is : select col1,explode(split(col2,'\\s')) from table_name; assume col2 is int type and col2 is string. ... View more

Hi everyone, In my hive table i have values in one column are like " Thu Dec 17 15:55:08 IST 2015 " .For this particular column i would like to find "week of the year".How can i do that one .Assume column name is survey_date and data type is string. ... View more