#10055: Incorrect DDL generated for views in ER Diagram Generator for hive | Aqua Data Studio

Issues
Search Tips

Easily find issues by searching: #<Issue ID>
Example: #1832

Easily find members by searching in: <username>, <first name> and <last name>.

Example: Search smith, will return results smith and adamsmith
You can use:
- Boolean operators AND, OR and NOT (must be in caps, e.g. oracle AND debugger, debugger NOT oracle)
- Single and multiple character wildcard (e.g. de?ug, debug*)
- Grouping (e.g. ((oracle debugger) AND exception))
- Quoted phrase (e.g. "Oracle Debugger")

#loadingpage {display:none}JavaScript and Cookies must be enabled in order for you to use AquaClusters.here

Aqua Data Studio / nhilam

Follow 829

IDE for Relational Databases

Back

Tariq Rahiman

tariqrahiman reported Sep 18, 2013 · last modified Oct 2, 2013

Incorrect DDL generated for views in ER Diagram Generator for hive

Dev	JennyNishimura
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	Hive
Version	14.0

Product: Aqua Data Studio

Version: 14.0.0-rc-22

Build #: 34051

Build Date: 2013-Sep-18 11:37:21 AM

Incorrect DDL generated for views in ER Diagram Generator

As is repeated twice.

TO reproduce

1. create a view in a database

2. Use Tools-> ER Diagram Generator and in the ER Model go to SQL Preview

3. As below there will be 2 AS in the DDL

CREATE VIEW tst_v1

AS

AS

SELECT * FROM tst1

See attached pic

1 attachment

Screen Shot 2013-09-18 at 3.30.44 PM.png

Sep 18, 2013

42 KB

All Comments (1) Change History

Tariq Rahiman

tariqrahiman Oct 2, 2013

Verified in 14.0.0-rc-41

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017