hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Xiu (JIRA)" <>
Subject [jira] [Updated] (HIVE-3194) implement the JDBC canonical/ISO-SQL 2012 scalar functions
Date Tue, 27 Aug 2013 22:09:51 GMT


Xiu updated HIVE-3194:

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

This patch supplies information on canonical JDBC scalar functions in HiveDatabaseMetaData
class by providing a comma-separated list of the Open Group CLI names of numeric functions
and string functions. The corresponding testcase is also added.

In terms of mod(), Hive is supporting "a % b" but not mod(a, b) right now, unlike MySQL, which
supports both.

The support of semantic "mod(a, b)" should be a good idea. I will create another JIRA for
> implement the JDBC canonical/ISO-SQL 2012 scalar functions
> ----------------------------------------------------------
>                 Key: HIVE-3194
>                 URL:
>             Project: Hive
>          Issue Type: Improvement
>          Components: JDBC, SQL, UDF
>    Affects Versions: 0.11.0, 0.8.0
>            Reporter: N Campbell
>         Attachments: Hive-3194.patch
> The Hive driver does not return any canonical JDBC scalar functions (per JDBC 3.0/4.0).
Similarly, while Hive has various 'similar' scalar functions their signature (name etc) is
not the same as ISO-SQL equivalent. It would be better for portable dynamic SQL applications
to see more alignment by Hive etc to both standards. In some cases it is small syntactic changes/tweaks
(i.e. see mod, substring etc).

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see:

View raw message