This project is an independent version of "Project Panthera".
- git clone https://github.com/adrian-wang/project-panthera-skin.git
- cd project-panthera-skin/
- ...........
- panthera > select a from x where b > (select max(c) from y);
-
- Support all Hive query syntax which is compatible SQL92.
-
- Base on 1, Panthera ASE support:
| Feature | Comment | Example |
| Multi-Table in FROM clause | select * from x,y where x.a=y.b | |
| Subquery in WHERE clause | Not support non-equal joint condition | select a from x where a = (select max(c) from y) |
| Subquery in HAVING clause | Not support non-equal joint condition | select max(a) from x group by b having max(a) = (select max(c) from y) |
| Order by column position | select a,b from x order by 1 | |
| Top level UNION ALL | select a from x union all select a from y |
- You can also click here to see what ASE supports in detail.