Re: Whatever happened to the MACRO facility, Hive-2655

2013-01-26 Thread David Morel
On 26 Jan 2013, at 14:59, Dean Wampler wrote: We mentioned it in our book and now I realize it's not actually implemented, even in 0.10.0. OOPS!! https://issues.apache.org/jira/browse/HIVE-2655 dean That's funny I was just about to post the same message :-) Came across it in the book on fri

Re: Whatever happened to the MACRO facility, Hive-2655

2013-01-26 Thread Dean Wampler
Great! It would be nice to have. dean On Sat, Jan 26, 2013 at 10:30 AM, Edward Capriolo wrote: > That is my fault I was hoping it would get in because it seems close. Ill > see if i can shove the ticket along. It is a cool feature. > > > On Sat, Jan 26, 2013 at 8:59 AM, Dean Wampler < > dean.wam

Re: Lateral View in sub query issue

2013-01-26 Thread Mark Grover
Hi John, Thanks for reporting this. Can you please take a look at the Lateral View issues here: https://issues.apache.org/jira/issues/?jql=project%20%3D%20HIVE%20AND%20text%20~%20%22lateral%20view%22 and create a new JIRA with the details if one previously doesn't exist? Thanks again, Mark On F

Re: Whatever happened to the MACRO facility, Hive-2655

2013-01-26 Thread Edward Capriolo
That is my fault I was hoping it would get in because it seems close. Ill see if i can shove the ticket along. It is a cool feature. On Sat, Jan 26, 2013 at 8:59 AM, Dean Wampler < dean.wamp...@thinkbiganalytics.com> wrote: > We mentioned it in our book and now I realize it's not actually > imple

Re: Is this a known Bug: Multi Inserts from partitioned source ignore Where Clauses

2013-01-26 Thread John Omernik
I am not a code expert, this looks very much like the bug I posted, but my bug is not using INSERT OVERWRITE (just INSERT INTO) and I am not doing any group by (probably not an issue) Just to be clear, this is probably the same issue as mine, but if someone with more knowledge of the underlying st

Re: Is this a known Bug: Multi Inserts from partitioned source ignore Where Clauses

2013-01-26 Thread Philip Tromans
This is a known (recently fixed) bug: https://issues.apache.org/jira/browse/HIVE-3699 Phil. On 26 January 2013 15:17, John Omernik wrote: > I ran into an interesting bug. Basically, if your FROM() source is > a partitioned table and you use a where clause that prunes, all of the > INSERT HERE

Is this a known Bug: Multi Inserts from partitioned source ignore Where Clauses

2013-01-26 Thread John Omernik
I ran into an interesting bug. Basically, if your FROM() source is a partitioned table and you use a where clause that prunes, all of the INSERT HERE SELECT * WHERE x=y ignores each specified where clause. This does not occur if the source partition is not specified, but if the source as where par

Whatever happened to the MACRO facility, Hive-2655

2013-01-26 Thread Dean Wampler
We mentioned it in our book and now I realize it's not actually implemented, even in 0.10.0. OOPS!! https://issues.apache.org/jira/browse/HIVE-2655 dean -- *Dean Wampler, Ph.D.* thinkbiganalytics.com +1-312-339-1330