Product: Aqua Data Studio

Version: 19.0.0-dev-15

Build #: 53837

Build Date: 2017-Apr-04 09:56:20 PM

 

Operating Environment: Linux (4.4.0-42-generic, amd64) / UTF-8 / en / US / Oracle Corporation 1.8.0_102-b14

Memory: Max=704,643,072; Total=315,621,376; Free=183,517,864; CPUs=8

 

Steps to Reproduce:-

1. Launch ADS

2. Connect to Greenplum Database version 4.3.12.0.

3. Expand Database node.

4. Expand Schema tree node.

5. Right click on Schema ->Select Query Analyzer.

6. In Query Analyzer Execute below script.

 

CREATE EXTERNAL TABLE ext_customer
   (id int, name text, sponsor text) 
   LOCATION ( 'gpfdist://filehost:8081/*.txt' ) 
   FORMAT 'TEXT' ( DELIMITER '|' NULL ' ')
   LOG ERRORS INTO err_customer SEGMENT REJECT LIMIT 5;

7. Script gets executed successfully.

8. Go to Table tree node ->Expand it.

9. Right Click on Created table and Select Script Object to Window As -> Create.

 

Result:-

Full Script does not get generated i.e. Location of the file which we have given while creating external table is not getting displayed.

 

Expected Result:-

Location of the file which we have given while creating external table should get displayed.

 

Observations:-

 

 

Behaviour in different ADS builds.	Behaviour of External table.
	WINDOWS	UBUNTU	MAC
ADS 19 dev-15	Y	Y	Y
ADS v18	Y	Y	Y
ADS v17	Y	Y	Y
Y - Issue is Reproducible.
N - Issue is not reproducible.

 

It is also Observed that on Native tool if we try to perform same steps then Location is getting displayed in Create Script.

 

Please refer this image for native tool behaviour.