[
https://issues.apache.org/jira/browse/HIVE-3194?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
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 this.
> implement the JDBC canonical/ISO-SQL 2012 scalar functions
> ----------------------------------------------------------
>
> Key: HIVE-3194
> URL: https://issues.apache.org/jira/browse/HIVE-3194
> 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: http://www.atlassian.com/software/jira
