Re: Work around for using OR in Joins

Ning, Thanks for the reply. Yes. you are right. Using NOT and AND didn't work as expected. I'll give a try in implementing nested-loop map-side join. In the meanwhile, I brought out the expression using OR from inside the JOIN expression to be used in the filtering expression {in the WHERE clause

Re: Work around for using OR in Joins

What is your OR conditions? Are they involving both tables? Can you post your query here? On Mar 23, 2011, at 12:04 AM, MIS wrote: > Ning, Thanks for the reply. > Yes. you are right. Using NOT and AND didn't work as expected. > I'll give a try in implementing nested-loop map-side join. > > In t

[jira] [Created] (HIVE-2072) set hive.exec.reducers.max= is not working to view

set hive.exec.reducers.max= is not working to view -- Key: HIVE-2072 URL: https://issues.apache.org/jira/browse/HIVE-2072 Project: Hive Issue Type: Bug Components: CLI Aff

Re: Work around for using OR in Joins

Here is my query :* select table1.column10, table1.column11, count(distinct table2.column3) as total from table1 JOIN table2 ON (table1.column1='value1' and to_date(table1.column2) >= '2011-01-06' and to_date(table1.column2) < '2011-01-07' and table2.column3!='' and table2.column3 is NOT NULL and

Jenkins build is back to normal : Hive-trunk-h0.20 #635

See

[jira] [Commented] (HIVE-1675) SAXParseException on plan.xml during local mode.

[ https://issues.apache.org/jira/browse/HIVE-1675?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13010099#comment-13010099 ] Bennie Schut commented on HIVE-1675: I'm unable to reproduce this on the current trunk.

[jira] [Created] (HIVE-2073) java.lang.IllegalStateException(Shutdown in progress) on local mode

java.lang.IllegalStateException(Shutdown in progress) on local mode --- Key: HIVE-2073 URL: https://issues.apache.org/jira/browse/HIVE-2073 Project: Hive Issue Type: Bug

[jira] [Commented] (HIVE-1675) SAXParseException on plan.xml during local mode.

[ https://issues.apache.org/jira/browse/HIVE-1675?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13010103#comment-13010103 ] Bennie Schut commented on HIVE-1675: Added HIVE-2073 for the different error we now get

[jira] [Commented] (HIVE-2073) java.lang.IllegalStateException(Shutdown in progress) on local mode

[ https://issues.apache.org/jira/browse/HIVE-2073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13010102#comment-13010102 ] Bennie Schut commented on HIVE-2073: 2011-03-23 12:40:18,154 ERROR exec.MapRedTask (Map

[jira] [Resolved] (HIVE-1675) SAXParseException on plan.xml during local mode.

[ https://issues.apache.org/jira/browse/HIVE-1675?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bennie Schut resolved HIVE-1675. Resolution: Cannot Reproduce Fix Version/s: 0.8.0 > SAXParseException on plan.xml during loca

[jira] [Commented] (HIVE-2073) java.lang.IllegalStateException(Shutdown in progress) on local mode

[ https://issues.apache.org/jira/browse/HIVE-2073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13010125#comment-13010125 ] Bennie Schut commented on HIVE-2073: On the Context class this call seems to go wrong:

[jira] [Commented] (HIVE-2073) java.lang.IllegalStateException(Shutdown in progress) on local mode

[ https://issues.apache.org/jira/browse/HIVE-2073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13010134#comment-13010134 ] Bennie Schut commented on HIVE-2073: It seems we are trying to add some scratchDir stuf

Re: Meanings of privileges

Thanks a lot for the response, Yongqiang! Just a thought, inline. On Tue, Mar 22, 2011 at 7:28 PM, yongqiang he wrote: > >>INDEX - my best guess is that this allows me to create/drop indexes on a > table? > Yes. It is there for this purpose. > > >> Is it the case that if I have select access on

[jira] [Updated] (HIVE-2069) NullPointerException on getSchemas

[ https://issues.apache.org/jira/browse/HIVE-2069?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ning Zhang updated HIVE-2069: - Resolution: Fixed Hadoop Flags: [Reviewed] Status: Resolved (was: Patch Available) Commit

[jira] [Commented] (HIVE-1644) use filter pushdown for automatically accessing indexes

[ https://issues.apache.org/jira/browse/HIVE-1644?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13010285#comment-13010285 ] He Yongqiang commented on HIVE-1644: Hi Russell, FIL%SEL% maybe not not good enough, h

[jira] [Updated] (HIVE-1966) mapjoin operator should not load hashtable for each new inputfile if the hashtable to be loaded is already there.

[ https://issues.apache.org/jira/browse/HIVE-1966?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-1966: --- Attachment: HIVE-1966.1.patch quick fix. will start running tests... > mapjoin operator should not lo

[jira] [Assigned] (HIVE-1996) "LOAD DATA INPATH" fails when the table already contains a file of the same name

[ https://issues.apache.org/jira/browse/HIVE-1996?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kirk True reassigned HIVE-1996: --- Assignee: Chinna Rao Lalam (was: Kirk True) > "LOAD DATA INPATH" fails when the table already contain

Jenkins build is back to normal : Hive-0.7.0-h0.20 #51

See

[jira] [Commented] (HIVE-1644) use filter pushdown for automatically accessing indexes

[ https://issues.apache.org/jira/browse/HIVE-1644?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13010401#comment-13010401 ] Namit Jain commented on HIVE-1644: -- Also, can you add another check - only use the index i

[jira] [Commented] (HIVE-1965) Auto convert mapjoin should not throw exception if the top operator is union operator.

[ https://issues.apache.org/jira/browse/HIVE-1965?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13010451#comment-13010451 ] Namit Jain commented on HIVE-1965: -- +1 > Auto convert mapjoin should not throw exception

[jira] [Commented] (HIVE-1966) mapjoin operator should not load hashtable for each new inputfile if the hashtable to be loaded is already there.

[ https://issues.apache.org/jira/browse/HIVE-1966?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13010452#comment-13010452 ] Namit Jain commented on HIVE-1966: -- +1 > mapjoin operator should not load hashtable for e

[jira] [Commented] (HIVE-1965) Auto convert mapjoin should not throw exception if the top operator is union operator.

[ https://issues.apache.org/jira/browse/HIVE-1965?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13010453#comment-13010453 ] Namit Jain commented on HIVE-1965: -- +1 > Auto convert mapjoin should not throw exception

[jira] [Commented] (HIVE-1803) Implement bitmap indexing in Hive

[ https://issues.apache.org/jira/browse/HIVE-1803?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13010471#comment-13010471 ] He Yongqiang commented on HIVE-1803: I did not do a detailed look, overall the patch lo

[jira] [Commented] (HIVE-1803) Implement bitmap indexing in Hive

[ https://issues.apache.org/jira/browse/HIVE-1803?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13010482#comment-13010482 ] He Yongqiang commented on HIVE-1803: Did an offline discussion with namit on this jira.

[jira] [Commented] (HIVE-1965) Auto convert mapjoin should not throw exception if the top operator is union operator.

[ https://issues.apache.org/jira/browse/HIVE-1965?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13010508#comment-13010508 ] Liyin Tang commented on HIVE-1965: -- +1 > Auto convert mapjoin should not throw exception

[jira] [Commented] (HIVE-1966) mapjoin operator should not load hashtable for each new inputfile if the hashtable to be loaded is already there.

[ https://issues.apache.org/jira/browse/HIVE-1966?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13010510#comment-13010510 ] Liyin Tang commented on HIVE-1966: -- +1 > mapjoin operator should not load hashtable for e

[jira] [Commented] (HIVE-1920) DESCRIBE with comments is difficult to read

[ https://issues.apache.org/jira/browse/HIVE-1920?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13010514#comment-13010514 ] Adam Kramer commented on HIVE-1920: --- Default SHOULD show comments, but there needs to be

[jira] [Commented] (HIVE-2072) set hive.exec.reducers.max= is not working to view

[ https://issues.apache.org/jira/browse/HIVE-2072?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13010538#comment-13010538 ] YoungYik commented on HIVE-2072: I have made a mistake in my query SQL, just forget this is

[jira] [Updated] (HIVE-2072) test

[ https://issues.apache.org/jira/browse/HIVE-2072?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] YoungYik updated HIVE-2072: --- Component/s: (was: CLI) Description: (was: I create two views from one table of differe

[jira] [Resolved] (HIVE-1965) Auto convert mapjoin should not throw exception if the top operator is union operator.

[ https://issues.apache.org/jira/browse/HIVE-1965?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain resolved HIVE-1965. -- Resolution: Fixed Committed. Thanks Yongqiang > Auto convert mapjoin should not throw exception if the