Description

zhumin-zizhu

opened on May 1, 2022

Issue body actions

SQL Example

• Simplyfied Query Exmple, focusing on the failing feature

 ALTER TABLE tablename add column (field  string)

Software Information

• JSqlParser version
• Database (hive )

Activity

1. manticore-projects commented on May 1, 2022

   

   manticore-projects

   on May 1, 2022

   Contributor

   More actions

   Greetings.

   Thank you for your report. Unfortunately HIVE seems to prefer its own SQL dialect far away from the SQL Standard:

   ALTER TABLE name ADD COLUMNS (col_spec[, col_spec ...])

   Pay attention to the COLUMNS keyword.

   Its not supported by JSQLParser and you would need to either send a PR or sponsor an implementation to make Hive support happening.
2. manticore-projects commented on May 1, 2022

   

   manticore-projects

   on May 1, 2022

   Contributor

   More actions

   From https://www.ibm.com/analytics/hadoop/hive: "Hive enables SQL developers to write Hive Query Language (HQL) statements that are similar to standard SQL statements for data query and analysis."

   Emphasis is on similar. I
3. zhumin-zizhu

   added a commit that references this issue on Jul 30, 2022

   JSQLParser#1524 support hive alter sql : ALTER TABLE name ADD COLUMNS…

   341d6f2
4. wumpz

   added a commit that references this issue on Aug 3, 2022

   #1524 support hive alter sql : ALTER TABLE name ADD COLUMNS (col_spec…

   fb6e950
5. manticore-projects

   added a commit that references this issue on Aug 4, 2022

   Fixes broken PR JSQLParser#1524 and Commit fb6e950

   796893d
6. zhumin-zizhu

   closed this as completedon Aug 4, 2022
7. zhumin-zizhu commented on Aug 4, 2022

   

   zhumin-zizhu

   on Aug 4, 2022

   ContributorAuthor

   More actions

   Has been resolved
8. wumpz

   added a commit that references this issue on Aug 14, 2022

   Fixes PR #1524 support hive alter sql (#1609)

   2619ce0
9. zhumin-zizhu

   added a commit that references this issue on Aug 18, 2022

   JSQLParser#1524 support presto create sql : CREATE TABLE aaaa (id int…

   8762946
10. wumpz

    added a commit that references this issue on Oct 25, 2022

    Enhanced Keywords (#1382)

    4863eb5
11. wumpz

    added a commit that references this issue on Nov 2, 2022

    Keywords2: Update whitelisted Keywords (#1653)

    f3e04b3
12. wumpz

    added a commit that references this issue on Jan 20, 2023

    Sphinx Website (#1624)

    be8e7a8

Issue actions