You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Chinna Rao Lalam (JIRA)" <ji...@apache.org> on 2011/08/24 15:55:38 UTC

[jira] [Created] (HIVE-2402) Function like with empty string is throwing null pointer exception

Function like with empty string is throwing null pointer exception
------------------------------------------------------------------

                 Key: HIVE-2402
                 URL: https://issues.apache.org/jira/browse/HIVE-2402
             Project: Hive
          Issue Type: Bug
          Components: Query Processor
         Environment: Hadoop 0.20.1, Hive0.8.0 and SUSE Linux Enterprise Server 10 SP2 (i586) - Kernel 2.6.16.60-0.21-smp (5)
            Reporter: Chinna Rao Lalam


select emp.ename from emp where ename like ''
This query is throwing null pointer exception

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Updated] (HIVE-2402) Function like with empty string is throwing null pointer exception

Posted by "Chinna Rao Lalam (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-2402?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chinna Rao Lalam updated HIVE-2402:
-----------------------------------

    Status: Patch Available  (was: Open)

> Function like with empty string is throwing null pointer exception
> ------------------------------------------------------------------
>
>                 Key: HIVE-2402
>                 URL: https://issues.apache.org/jira/browse/HIVE-2402
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.8.0
>         Environment: Hadoop 0.20.1, Hive0.8.0 and SUSE Linux Enterprise Server 10 SP2 (i586) - Kernel 2.6.16.60-0.21-smp (5)
>            Reporter: Chinna Rao Lalam
>            Assignee: Chinna Rao Lalam
>         Attachments: HIVE-2402.1.patch, HIVE-2402.patch
>
>
> select emp.ename from emp where ename like ''
> This query is throwing null pointer exception

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Updated] (HIVE-2402) Function like with empty string is throwing null pointer exception

Posted by "John Sichi (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-2402?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

John Sichi updated HIVE-2402:
-----------------------------

       Resolution: Fixed
    Fix Version/s: 0.9.0
     Hadoop Flags: [Reviewed]
           Status: Resolved  (was: Patch Available)

Committed to trunk.  Thanks Chinna!


> Function like with empty string is throwing null pointer exception
> ------------------------------------------------------------------
>
>                 Key: HIVE-2402
>                 URL: https://issues.apache.org/jira/browse/HIVE-2402
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.8.0
>         Environment: Hadoop 0.20.1, Hive0.8.0 and SUSE Linux Enterprise Server 10 SP2 (i586) - Kernel 2.6.16.60-0.21-smp (5)
>            Reporter: Chinna Rao Lalam
>            Assignee: Chinna Rao Lalam
>             Fix For: 0.9.0
>
>         Attachments: HIVE-2402.1.patch, HIVE-2402.patch
>
>
> select emp.ename from emp where ename like ''
> This query is throwing null pointer exception

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Updated] (HIVE-2402) Function like with empty string is throwing null pointer exception

Posted by "Venu Gopala Rao (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-2402?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Venu Gopala Rao updated HIVE-2402:
----------------------------------

    Affects Version/s: 0.8.0
               Status: Patch Available  (was: Open)

> Function like with empty string is throwing null pointer exception
> ------------------------------------------------------------------
>
>                 Key: HIVE-2402
>                 URL: https://issues.apache.org/jira/browse/HIVE-2402
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.8.0
>         Environment: Hadoop 0.20.1, Hive0.8.0 and SUSE Linux Enterprise Server 10 SP2 (i586) - Kernel 2.6.16.60-0.21-smp (5)
>            Reporter: Chinna Rao Lalam
>         Attachments: HIVE-2402.patch
>
>
> select emp.ename from emp where ename like ''
> This query is throwing null pointer exception

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Commented] (HIVE-2402) Function like with empty string is throwing null pointer exception

Posted by "John Sichi (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-2402?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13100569#comment-13100569 ] 

John Sichi commented on HIVE-2402:
----------------------------------

+1.  Will commit when tests pass.


> Function like with empty string is throwing null pointer exception
> ------------------------------------------------------------------
>
>                 Key: HIVE-2402
>                 URL: https://issues.apache.org/jira/browse/HIVE-2402
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.8.0
>         Environment: Hadoop 0.20.1, Hive0.8.0 and SUSE Linux Enterprise Server 10 SP2 (i586) - Kernel 2.6.16.60-0.21-smp (5)
>            Reporter: Chinna Rao Lalam
>            Assignee: Chinna Rao Lalam
>         Attachments: HIVE-2402.1.patch, HIVE-2402.patch
>
>
> select emp.ename from emp where ename like ''
> This query is throwing null pointer exception

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Commented] (HIVE-2402) Function like with empty string is throwing null pointer exception

Posted by "jiraposter@reviews.apache.org (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-2402?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13100495#comment-13100495 ] 

jiraposter@reviews.apache.org commented on HIVE-2402:
-----------------------------------------------------


-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/1757/
-----------------------------------------------------------

Review request for hive and John Sichi.


Summary
-------

By default patterntype is complex so it is expecting Pattern object but in this scenario pattern object is null so it is throwing nullpointer exception. Default patterntype can be NONE and in parseSimplePattern() it will be assigned with right type.


This addresses bug HIVE-2402.
    https://issues.apache.org/jira/browse/HIVE-2402


Diffs
-----

  trunk/ql/src/java/org/apache/hadoop/hive/ql/udf/UDFLike.java 1165244 
  trunk/ql/src/test/queries/clientpositive/udf_like.q 1165244 
  trunk/ql/src/test/results/clientpositive/udf_like.q.out 1165244 

Diff: https://reviews.apache.org/r/1757/diff


Testing
-------

Added unit testcase.


Thanks,

chinna



> Function like with empty string is throwing null pointer exception
> ------------------------------------------------------------------
>
>                 Key: HIVE-2402
>                 URL: https://issues.apache.org/jira/browse/HIVE-2402
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.8.0
>         Environment: Hadoop 0.20.1, Hive0.8.0 and SUSE Linux Enterprise Server 10 SP2 (i586) - Kernel 2.6.16.60-0.21-smp (5)
>            Reporter: Chinna Rao Lalam
>            Assignee: Chinna Rao Lalam
>         Attachments: HIVE-2402.1.patch, HIVE-2402.patch
>
>
> select emp.ename from emp where ename like ''
> This query is throwing null pointer exception

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Commented] (HIVE-2402) Function like with empty string is throwing null pointer exception

Posted by "John Sichi (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-2402?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13094196#comment-13094196 ] 

John Sichi commented on HIVE-2402:
----------------------------------

I'm curious:  why is it not possible to actually support an empty string as the like pattern?  It's not particularly useful, but should be no different from any other wildcardless pattern.


> Function like with empty string is throwing null pointer exception
> ------------------------------------------------------------------
>
>                 Key: HIVE-2402
>                 URL: https://issues.apache.org/jira/browse/HIVE-2402
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.8.0
>         Environment: Hadoop 0.20.1, Hive0.8.0 and SUSE Linux Enterprise Server 10 SP2 (i586) - Kernel 2.6.16.60-0.21-smp (5)
>            Reporter: Chinna Rao Lalam
>            Assignee: Chinna Rao Lalam
>         Attachments: HIVE-2402.patch
>
>
> select emp.ename from emp where ename like ''
> This query is throwing null pointer exception

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Updated] (HIVE-2402) Function like with empty string is throwing null pointer exception

Posted by "John Sichi (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-2402?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

John Sichi updated HIVE-2402:
-----------------------------

    Status: Open  (was: Patch Available)

> Function like with empty string is throwing null pointer exception
> ------------------------------------------------------------------
>
>                 Key: HIVE-2402
>                 URL: https://issues.apache.org/jira/browse/HIVE-2402
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.8.0
>         Environment: Hadoop 0.20.1, Hive0.8.0 and SUSE Linux Enterprise Server 10 SP2 (i586) - Kernel 2.6.16.60-0.21-smp (5)
>            Reporter: Chinna Rao Lalam
>            Assignee: Chinna Rao Lalam
>         Attachments: HIVE-2402.patch
>
>
> select emp.ename from emp where ename like ''
> This query is throwing null pointer exception

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Updated] (HIVE-2402) Function like with empty string is throwing null pointer exception

Posted by "Venu Gopala Rao (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-2402?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Venu Gopala Rao updated HIVE-2402:
----------------------------------

    Attachment: HIVE-2402.patch

> Function like with empty string is throwing null pointer exception
> ------------------------------------------------------------------
>
>                 Key: HIVE-2402
>                 URL: https://issues.apache.org/jira/browse/HIVE-2402
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>         Environment: Hadoop 0.20.1, Hive0.8.0 and SUSE Linux Enterprise Server 10 SP2 (i586) - Kernel 2.6.16.60-0.21-smp (5)
>            Reporter: Chinna Rao Lalam
>         Attachments: HIVE-2402.patch
>
>
> select emp.ename from emp where ename like ''
> This query is throwing null pointer exception

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Assigned] (HIVE-2402) Function like with empty string is throwing null pointer exception

Posted by "John Sichi (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-2402?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

John Sichi reassigned HIVE-2402:
--------------------------------

    Assignee: Chinna Rao Lalam

> Function like with empty string is throwing null pointer exception
> ------------------------------------------------------------------
>
>                 Key: HIVE-2402
>                 URL: https://issues.apache.org/jira/browse/HIVE-2402
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.8.0
>         Environment: Hadoop 0.20.1, Hive0.8.0 and SUSE Linux Enterprise Server 10 SP2 (i586) - Kernel 2.6.16.60-0.21-smp (5)
>            Reporter: Chinna Rao Lalam
>            Assignee: Chinna Rao Lalam
>         Attachments: HIVE-2402.patch
>
>
> select emp.ename from emp where ename like ''
> This query is throwing null pointer exception

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Commented] (HIVE-2402) Function like with empty string is throwing null pointer exception

Posted by "Chinna Rao Lalam (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-2402?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13100491#comment-13100491 ] 

Chinna Rao Lalam commented on HIVE-2402:
----------------------------------------

By default patterntype is complex so it is expecting Pattern object but in this scenario pattern object is null so it is throwing nullpointer exception. Default patterntype can be NONE and in parseSimplePattern() it will be assigned with right type.

> Function like with empty string is throwing null pointer exception
> ------------------------------------------------------------------
>
>                 Key: HIVE-2402
>                 URL: https://issues.apache.org/jira/browse/HIVE-2402
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.8.0
>         Environment: Hadoop 0.20.1, Hive0.8.0 and SUSE Linux Enterprise Server 10 SP2 (i586) - Kernel 2.6.16.60-0.21-smp (5)
>            Reporter: Chinna Rao Lalam
>            Assignee: Chinna Rao Lalam
>         Attachments: HIVE-2402.1.patch, HIVE-2402.patch
>
>
> select emp.ename from emp where ename like ''
> This query is throwing null pointer exception

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Updated] (HIVE-2402) Function like with empty string is throwing null pointer exception

Posted by "Chinna Rao Lalam (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-2402?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chinna Rao Lalam updated HIVE-2402:
-----------------------------------

    Attachment: HIVE-2402.1.patch

> Function like with empty string is throwing null pointer exception
> ------------------------------------------------------------------
>
>                 Key: HIVE-2402
>                 URL: https://issues.apache.org/jira/browse/HIVE-2402
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.8.0
>         Environment: Hadoop 0.20.1, Hive0.8.0 and SUSE Linux Enterprise Server 10 SP2 (i586) - Kernel 2.6.16.60-0.21-smp (5)
>            Reporter: Chinna Rao Lalam
>            Assignee: Chinna Rao Lalam
>         Attachments: HIVE-2402.1.patch, HIVE-2402.patch
>
>
> select emp.ename from emp where ename like ''
> This query is throwing null pointer exception

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Commented] (HIVE-2402) Function like with empty string is throwing null pointer exception

Posted by "Hudson (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-2402?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13101070#comment-13101070 ] 

Hudson commented on HIVE-2402:
------------------------------

Integrated in Hive-trunk-h0.21 #944 (See [https://builds.apache.org/job/Hive-trunk-h0.21/944/])
    HIVE-2402. Function like with empty string is throwing null pointer exception
(Chinna Rao Lalam via jvs)

jvs : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1166941
Files : 
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/udf/UDFLike.java
* /hive/trunk/ql/src/test/queries/clientpositive/udf_like.q
* /hive/trunk/ql/src/test/results/clientpositive/udf_like.q.out


> Function like with empty string is throwing null pointer exception
> ------------------------------------------------------------------
>
>                 Key: HIVE-2402
>                 URL: https://issues.apache.org/jira/browse/HIVE-2402
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.8.0
>         Environment: Hadoop 0.20.1, Hive0.8.0 and SUSE Linux Enterprise Server 10 SP2 (i586) - Kernel 2.6.16.60-0.21-smp (5)
>            Reporter: Chinna Rao Lalam
>            Assignee: Chinna Rao Lalam
>             Fix For: 0.9.0
>
>         Attachments: HIVE-2402.1.patch, HIVE-2402.patch
>
>
> select emp.ename from emp where ename like ''
> This query is throwing null pointer exception

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira