You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by Carter Shanklin <ca...@hortonworks.com> on 2017/01/13 17:09:08 UTC

Adding a Hive Statement of SQL Conformance to the docs

I get asked from time to time what Hive's level of SQL conformance is, and it's difficult to provide a clean answer. Most SQL systems have some detailed statement of SQL conformance to help answer this question.

For a year or so I've maintained a spreadsheet that tracks Hive's SQL conformance, inspired by the Postgres SQL Conformance page<https://www.postgresql.org/docs/9.5/static/features.html>. I've copied this spreadsheet into a publicly viewable Google Spreadsheet here: https://docs.google.com/spreadsheets/d/1VaAqkPXtjhT_oYniUW1I2xMmAFlxqp2UFkemL9-U14Q/edit#gid=0

I propose to add a static version of this document to the Hive Wiki, and to version it with one static SQL Conformance page per Hive major release, starting with Hive 2.1 and moving forward. So for example there would be one page for Hive 2.1, one for Hive 2.2 when it is released, and so on.

At this point I don't guarantee the spreadsheet's complete accuracy. Getting it into the public wiki with multiple editors should quickly eliminate any errors.

Does anyone have comments, suggestions or objections?

Thanks,

Re: Adding a Hive Statement of SQL Conformance to the docs

Posted by Lefty Leverenz <le...@gmail.com>.

+1

Good idea.  We'll add crossreferences from various places in the wiki, such
as Hive Versions and Branches
<https://cwiki.apache.org/confluence/display/Hive/Home#Home-HiveVersionsandBranches>
and
the Language Manual
<https://cwiki.apache.org/confluence/display/Hive/LanguageManual> umbrella
page.  (Also DDL
<https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL>, DML
<https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML>, and
Select
<https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Select>.)

Thanks, Carter.

-- Lefty

On Fri, Jan 13, 2017 at 9:48 AM, Alan Gates <al...@gmail.com> wrote:

> +1.  I think this will be great for existing and potential Hive users.
>
> Alan.
>
> > On Jan 13, 2017, at 9:09 AM, Carter Shanklin <ca...@hortonworks.com>
> wrote:
> >
> > I get asked from time to time what Hive's level of SQL conformance is,
> and it's difficult to provide a clean answer. Most SQL systems have some
> detailed statement of SQL conformance to help answer this question.
> >
> > For a year or so I've maintained a spreadsheet that tracks Hive's SQL
> conformance, inspired by the Postgres SQL Conformance page. I've copied
> this spreadsheet into a publicly viewable Google Spreadsheet here:
> https://docs.google.com/spreadsheets/d/1VaAqkPXtjhT_
> oYniUW1I2xMmAFlxqp2UFkemL9-U14Q/edit#gid=0
> >
> > I propose to add a static version of this document to the Hive Wiki, and
> to version it with one static SQL Conformance page per Hive major release,
> starting with Hive 2.1 and moving forward. So for example there would be
> one page for Hive 2.1, one for Hive 2.2 when it is released, and so on.
> >
> > At this point I don't guarantee the spreadsheet's complete accuracy.
> Getting it into the public wiki with multiple editors should quickly
> eliminate any errors.
> >
> > Does anyone have comments, suggestions or objections?
> >
> > Thanks,
> >
>
>

Re: Adding a Hive Statement of SQL Conformance to the docs

Posted by Alan Gates <al...@gmail.com>.

+1.  I think this will be great for existing and potential Hive users.

Alan.

> On Jan 13, 2017, at 9:09 AM, Carter Shanklin <ca...@hortonworks.com> wrote:
> 
> I get asked from time to time what Hive's level of SQL conformance is, and it's difficult to provide a clean answer. Most SQL systems have some detailed statement of SQL conformance to help answer this question.
> 
> For a year or so I've maintained a spreadsheet that tracks Hive's SQL conformance, inspired by the Postgres SQL Conformance page. I've copied this spreadsheet into a publicly viewable Google Spreadsheet here: https://docs.google.com/spreadsheets/d/1VaAqkPXtjhT_oYniUW1I2xMmAFlxqp2UFkemL9-U14Q/edit#gid=0
> 
> I propose to add a static version of this document to the Hive Wiki, and to version it with one static SQL Conformance page per Hive major release, starting with Hive 2.1 and moving forward. So for example there would be one page for Hive 2.1, one for Hive 2.2 when it is released, and so on.
> 
> At this point I don't guarantee the spreadsheet's complete accuracy. Getting it into the public wiki with multiple editors should quickly eliminate any errors.
> 
> Does anyone have comments, suggestions or objections?
> 
> Thanks,
>