You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Carl Steinbach (JIRA)" <ji...@apache.org> on 2010/01/06 23:10:54 UTC
[jira] Created: (HIVE-1031) "DESCRIBE FUNCTION array" throws
ParseException
"DESCRIBE FUNCTION array" throws ParseException
-----------------------------------------------
Key: HIVE-1031
URL: https://issues.apache.org/jira/browse/HIVE-1031
Project: Hadoop Hive
Issue Type: Bug
Components: Query Processor
Reporter: Carl Steinbach
Assignee: Carl Steinbach
{noformat}
hive> describe function array;
describe function array;
FAILED: Parse Error: line 1:18 cannot recognize input 'array' in describe statement
hive> describe function 'array';
describe function 'array';
OK
array(n0, n1...) - Creates an array with the given elements
Time taken: 0.396 seconds
hive> describe function map;
describe function map;
FAILED: Parse Error: line 1:18 cannot recognize input 'map' in describe statement
hive> describe function 'map';
describe function 'map';
OK
map(key0, value0, key1, value1...) - Creates a map with the given key/value pairs
Time taken: 0.054 seconds
hive> describe function case;
describe function case;
FAILED: Parse Error: line 1:18 cannot recognize input 'case' in describe statement
hive> describe function 'case';
describe function 'case';
OK
There is no documentation for function case
Time taken: 0.072 seconds
{noformat}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-1031) "DESCRIBE FUNCTION array" throws
ParseException
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1031?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12797488#action_12797488 ]
Carl Steinbach commented on HIVE-1031:
--------------------------------------
@Namit: difficult, because there is overlap between this and HIVE-996. Would you like me to role this change into HIVE-996?
> "DESCRIBE FUNCTION array" throws ParseException
> -----------------------------------------------
>
> Key: HIVE-1031
> URL: https://issues.apache.org/jira/browse/HIVE-1031
> Project: Hadoop Hive
> Issue Type: Bug
> Components: Query Processor
> Reporter: Carl Steinbach
> Assignee: Carl Steinbach
> Attachments: HIVE-1031.patch
>
>
> {noformat}
> hive> describe function array;
> describe function array;
> FAILED: Parse Error: line 1:18 cannot recognize input 'array' in describe statement
> hive> describe function 'array';
> describe function 'array';
> OK
> array(n0, n1...) - Creates an array with the given elements
> Time taken: 0.396 seconds
> hive> describe function map;
> describe function map;
> FAILED: Parse Error: line 1:18 cannot recognize input 'map' in describe statement
> hive> describe function 'map';
> describe function 'map';
> OK
> map(key0, value0, key1, value1...) - Creates a map with the given key/value pairs
> Time taken: 0.054 seconds
> hive> describe function case;
> describe function case;
> FAILED: Parse Error: line 1:18 cannot recognize input 'case' in describe statement
> hive> describe function 'case';
> describe function 'case';
> OK
> There is no documentation for function case
> Time taken: 0.072 seconds
> {noformat}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-1031) "DESCRIBE FUNCTION array" throws
ParseException
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1031?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain updated HIVE-1031:
-----------------------------
Resolution: Fixed
Fix Version/s: 0.5.0
Hadoop Flags: [Reviewed]
Status: Resolved (was: Patch Available)
Committed. Thanks Carl
> "DESCRIBE FUNCTION array" throws ParseException
> -----------------------------------------------
>
> Key: HIVE-1031
> URL: https://issues.apache.org/jira/browse/HIVE-1031
> Project: Hadoop Hive
> Issue Type: Bug
> Components: Query Processor
> Reporter: Carl Steinbach
> Assignee: Carl Steinbach
> Fix For: 0.5.0
>
> Attachments: HIVE-1031.2.patch, HIVE-1031.patch
>
>
> {noformat}
> hive> describe function array;
> describe function array;
> FAILED: Parse Error: line 1:18 cannot recognize input 'array' in describe statement
> hive> describe function 'array';
> describe function 'array';
> OK
> array(n0, n1...) - Creates an array with the given elements
> Time taken: 0.396 seconds
> hive> describe function map;
> describe function map;
> FAILED: Parse Error: line 1:18 cannot recognize input 'map' in describe statement
> hive> describe function 'map';
> describe function 'map';
> OK
> map(key0, value0, key1, value1...) - Creates a map with the given key/value pairs
> Time taken: 0.054 seconds
> hive> describe function case;
> describe function case;
> FAILED: Parse Error: line 1:18 cannot recognize input 'case' in describe statement
> hive> describe function 'case';
> describe function 'case';
> OK
> There is no documentation for function case
> Time taken: 0.072 seconds
> {noformat}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-1031) "DESCRIBE FUNCTION array" throws
ParseException
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1031?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12797489#action_12797489 ]
Carl Steinbach commented on HIVE-1031:
--------------------------------------
Sorry, didn't realize that HIVE-996 got committed. I will update the testcase.
> "DESCRIBE FUNCTION array" throws ParseException
> -----------------------------------------------
>
> Key: HIVE-1031
> URL: https://issues.apache.org/jira/browse/HIVE-1031
> Project: Hadoop Hive
> Issue Type: Bug
> Components: Query Processor
> Reporter: Carl Steinbach
> Assignee: Carl Steinbach
> Attachments: HIVE-1031.patch
>
>
> {noformat}
> hive> describe function array;
> describe function array;
> FAILED: Parse Error: line 1:18 cannot recognize input 'array' in describe statement
> hive> describe function 'array';
> describe function 'array';
> OK
> array(n0, n1...) - Creates an array with the given elements
> Time taken: 0.396 seconds
> hive> describe function map;
> describe function map;
> FAILED: Parse Error: line 1:18 cannot recognize input 'map' in describe statement
> hive> describe function 'map';
> describe function 'map';
> OK
> map(key0, value0, key1, value1...) - Creates a map with the given key/value pairs
> Time taken: 0.054 seconds
> hive> describe function case;
> describe function case;
> FAILED: Parse Error: line 1:18 cannot recognize input 'case' in describe statement
> hive> describe function 'case';
> describe function 'case';
> OK
> There is no documentation for function case
> Time taken: 0.072 seconds
> {noformat}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-1031) "DESCRIBE FUNCTION array" throws
ParseException
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1031?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Carl Steinbach updated HIVE-1031:
---------------------------------
Attachment: HIVE-1031.patch
> "DESCRIBE FUNCTION array" throws ParseException
> -----------------------------------------------
>
> Key: HIVE-1031
> URL: https://issues.apache.org/jira/browse/HIVE-1031
> Project: Hadoop Hive
> Issue Type: Bug
> Components: Query Processor
> Reporter: Carl Steinbach
> Assignee: Carl Steinbach
> Attachments: HIVE-1031.patch
>
>
> {noformat}
> hive> describe function array;
> describe function array;
> FAILED: Parse Error: line 1:18 cannot recognize input 'array' in describe statement
> hive> describe function 'array';
> describe function 'array';
> OK
> array(n0, n1...) - Creates an array with the given elements
> Time taken: 0.396 seconds
> hive> describe function map;
> describe function map;
> FAILED: Parse Error: line 1:18 cannot recognize input 'map' in describe statement
> hive> describe function 'map';
> describe function 'map';
> OK
> map(key0, value0, key1, value1...) - Creates a map with the given key/value pairs
> Time taken: 0.054 seconds
> hive> describe function case;
> describe function case;
> FAILED: Parse Error: line 1:18 cannot recognize input 'case' in describe statement
> hive> describe function 'case';
> describe function 'case';
> OK
> There is no documentation for function case
> Time taken: 0.072 seconds
> {noformat}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-1031) "DESCRIBE FUNCTION array" throws
ParseException
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1031?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Carl Steinbach updated HIVE-1031:
---------------------------------
Attachment: HIVE-1031.2.patch
> "DESCRIBE FUNCTION array" throws ParseException
> -----------------------------------------------
>
> Key: HIVE-1031
> URL: https://issues.apache.org/jira/browse/HIVE-1031
> Project: Hadoop Hive
> Issue Type: Bug
> Components: Query Processor
> Reporter: Carl Steinbach
> Assignee: Carl Steinbach
> Attachments: HIVE-1031.2.patch, HIVE-1031.patch
>
>
> {noformat}
> hive> describe function array;
> describe function array;
> FAILED: Parse Error: line 1:18 cannot recognize input 'array' in describe statement
> hive> describe function 'array';
> describe function 'array';
> OK
> array(n0, n1...) - Creates an array with the given elements
> Time taken: 0.396 seconds
> hive> describe function map;
> describe function map;
> FAILED: Parse Error: line 1:18 cannot recognize input 'map' in describe statement
> hive> describe function 'map';
> describe function 'map';
> OK
> map(key0, value0, key1, value1...) - Creates a map with the given key/value pairs
> Time taken: 0.054 seconds
> hive> describe function case;
> describe function case;
> FAILED: Parse Error: line 1:18 cannot recognize input 'case' in describe statement
> hive> describe function 'case';
> describe function 'case';
> OK
> There is no documentation for function case
> Time taken: 0.072 seconds
> {noformat}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-1031) "DESCRIBE FUNCTION array" throws
ParseException
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1031?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12797353#action_12797353 ]
Namit Jain commented on HIVE-1031:
----------------------------------
Seems to be a problem with reserved words.
> "DESCRIBE FUNCTION array" throws ParseException
> -----------------------------------------------
>
> Key: HIVE-1031
> URL: https://issues.apache.org/jira/browse/HIVE-1031
> Project: Hadoop Hive
> Issue Type: Bug
> Components: Query Processor
> Reporter: Carl Steinbach
> Assignee: Carl Steinbach
>
> {noformat}
> hive> describe function array;
> describe function array;
> FAILED: Parse Error: line 1:18 cannot recognize input 'array' in describe statement
> hive> describe function 'array';
> describe function 'array';
> OK
> array(n0, n1...) - Creates an array with the given elements
> Time taken: 0.396 seconds
> hive> describe function map;
> describe function map;
> FAILED: Parse Error: line 1:18 cannot recognize input 'map' in describe statement
> hive> describe function 'map';
> describe function 'map';
> OK
> map(key0, value0, key1, value1...) - Creates a map with the given key/value pairs
> Time taken: 0.054 seconds
> hive> describe function case;
> describe function case;
> FAILED: Parse Error: line 1:18 cannot recognize input 'case' in describe statement
> hive> describe function 'case';
> describe function 'case';
> OK
> There is no documentation for function case
> Time taken: 0.072 seconds
> {noformat}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-1031) "DESCRIBE FUNCTION array" throws
ParseException
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1031?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Carl Steinbach updated HIVE-1031:
---------------------------------
Status: Patch Available (was: Open)
* Updated the list of "sysFuncNames" in the Hive grammar file.
{noformat}
hive> describe function array;
describe function array;
OK
array(n0, n1...) - Creates an array with the given elements
Time taken: 0.051 seconds
hive> describe function map;
describe function map;
OK
map(key0, value0, key1, value1...) - Creates a map with the given key/value pairs
Time taken: 0.069 seconds
{noformat}
> "DESCRIBE FUNCTION array" throws ParseException
> -----------------------------------------------
>
> Key: HIVE-1031
> URL: https://issues.apache.org/jira/browse/HIVE-1031
> Project: Hadoop Hive
> Issue Type: Bug
> Components: Query Processor
> Reporter: Carl Steinbach
> Assignee: Carl Steinbach
> Attachments: HIVE-1031.patch
>
>
> {noformat}
> hive> describe function array;
> describe function array;
> FAILED: Parse Error: line 1:18 cannot recognize input 'array' in describe statement
> hive> describe function 'array';
> describe function 'array';
> OK
> array(n0, n1...) - Creates an array with the given elements
> Time taken: 0.396 seconds
> hive> describe function map;
> describe function map;
> FAILED: Parse Error: line 1:18 cannot recognize input 'map' in describe statement
> hive> describe function 'map';
> describe function 'map';
> OK
> map(key0, value0, key1, value1...) - Creates a map with the given key/value pairs
> Time taken: 0.054 seconds
> hive> describe function case;
> describe function case;
> FAILED: Parse Error: line 1:18 cannot recognize input 'case' in describe statement
> hive> describe function 'case';
> describe function 'case';
> OK
> There is no documentation for function case
> Time taken: 0.072 seconds
> {noformat}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-1031) "DESCRIBE FUNCTION array" throws
ParseException
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1031?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12797589#action_12797589 ]
Carl Steinbach commented on HIVE-1031:
--------------------------------------
* Removed quotes from udf_case.q, udf_if.q, etc.
* Consistent naming for UDF testcases.
** One udf_xxx.q file for each entry in the output of "show functions"
* Fix for HIVE-899: Allow 'A != B' in place of 'A <> B'
** Added != testcase to udf_notequal.q
* Fix for HIVE-997: "describe function x" should list synonyms of x
{noformat}
hive> DESCRIBE FUNCTION std;
DESCRIBE FUNCTION std;
OK
std(x) - Returns the standard deviation of a set of numbers
Time taken: 0.1 seconds
hive> DESCRIBE FUNCTION EXTENDED std;
DESCRIBE FUNCTION EXTENDED std;
OK
std(x) - Returns the standard deviation of a set of numbers
Synonyms: stddev_pop, stddev
Time taken: 0.055 seconds
hive> DESCRIBE FUNCTION lower;
DESCRIBE FUNCTION lower;
OK
lower(str) - Returns str with all characters changed to lowercase
Time taken: 0.231 seconds
hive> DESCRIBE FUNCTION EXTENDED lower;
DESCRIBE FUNCTION EXTENDED lower;
OK
lower(str) - Returns str with all characters changed to lowercase
Synonyms: lcase
Example:
> SELECT lower('Facebook') FROM src LIMIT 1;
'facebook'
Time taken: 0.505 seconds
hive>
{noformat}
> "DESCRIBE FUNCTION array" throws ParseException
> -----------------------------------------------
>
> Key: HIVE-1031
> URL: https://issues.apache.org/jira/browse/HIVE-1031
> Project: Hadoop Hive
> Issue Type: Bug
> Components: Query Processor
> Reporter: Carl Steinbach
> Assignee: Carl Steinbach
> Attachments: HIVE-1031.2.patch, HIVE-1031.patch
>
>
> {noformat}
> hive> describe function array;
> describe function array;
> FAILED: Parse Error: line 1:18 cannot recognize input 'array' in describe statement
> hive> describe function 'array';
> describe function 'array';
> OK
> array(n0, n1...) - Creates an array with the given elements
> Time taken: 0.396 seconds
> hive> describe function map;
> describe function map;
> FAILED: Parse Error: line 1:18 cannot recognize input 'map' in describe statement
> hive> describe function 'map';
> describe function 'map';
> OK
> map(key0, value0, key1, value1...) - Creates a map with the given key/value pairs
> Time taken: 0.054 seconds
> hive> describe function case;
> describe function case;
> FAILED: Parse Error: line 1:18 cannot recognize input 'case' in describe statement
> hive> describe function 'case';
> describe function 'case';
> OK
> There is no documentation for function case
> Time taken: 0.072 seconds
> {noformat}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-1031) "DESCRIBE FUNCTION array" throws
ParseException
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1031?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12797718#action_12797718 ]
Namit Jain commented on HIVE-1031:
----------------------------------
+1
looks good - will commit if the tests pass
> "DESCRIBE FUNCTION array" throws ParseException
> -----------------------------------------------
>
> Key: HIVE-1031
> URL: https://issues.apache.org/jira/browse/HIVE-1031
> Project: Hadoop Hive
> Issue Type: Bug
> Components: Query Processor
> Reporter: Carl Steinbach
> Assignee: Carl Steinbach
> Attachments: HIVE-1031.2.patch, HIVE-1031.patch
>
>
> {noformat}
> hive> describe function array;
> describe function array;
> FAILED: Parse Error: line 1:18 cannot recognize input 'array' in describe statement
> hive> describe function 'array';
> describe function 'array';
> OK
> array(n0, n1...) - Creates an array with the given elements
> Time taken: 0.396 seconds
> hive> describe function map;
> describe function map;
> FAILED: Parse Error: line 1:18 cannot recognize input 'map' in describe statement
> hive> describe function 'map';
> describe function 'map';
> OK
> map(key0, value0, key1, value1...) - Creates a map with the given key/value pairs
> Time taken: 0.054 seconds
> hive> describe function case;
> describe function case;
> FAILED: Parse Error: line 1:18 cannot recognize input 'case' in describe statement
> hive> describe function 'case';
> describe function 'case';
> OK
> There is no documentation for function case
> Time taken: 0.072 seconds
> {noformat}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-1031) "DESCRIBE FUNCTION array" throws
ParseException
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1031?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12797469#action_12797469 ]
Namit Jain commented on HIVE-1031:
----------------------------------
can you add a test or change the existing test to remove quotes ?
> "DESCRIBE FUNCTION array" throws ParseException
> -----------------------------------------------
>
> Key: HIVE-1031
> URL: https://issues.apache.org/jira/browse/HIVE-1031
> Project: Hadoop Hive
> Issue Type: Bug
> Components: Query Processor
> Reporter: Carl Steinbach
> Assignee: Carl Steinbach
> Attachments: HIVE-1031.patch
>
>
> {noformat}
> hive> describe function array;
> describe function array;
> FAILED: Parse Error: line 1:18 cannot recognize input 'array' in describe statement
> hive> describe function 'array';
> describe function 'array';
> OK
> array(n0, n1...) - Creates an array with the given elements
> Time taken: 0.396 seconds
> hive> describe function map;
> describe function map;
> FAILED: Parse Error: line 1:18 cannot recognize input 'map' in describe statement
> hive> describe function 'map';
> describe function 'map';
> OK
> map(key0, value0, key1, value1...) - Creates a map with the given key/value pairs
> Time taken: 0.054 seconds
> hive> describe function case;
> describe function case;
> FAILED: Parse Error: line 1:18 cannot recognize input 'case' in describe statement
> hive> describe function 'case';
> describe function 'case';
> OK
> There is no documentation for function case
> Time taken: 0.072 seconds
> {noformat}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.