#12209: Impala- Schema Compare Tool- View Comment should is shown in script, though Include Comments option unchecked

anilkalshetti reported 2014-05-27T12:44:36Z · last modified 2017-05-22T17:43:17Z

Impala- Schema Compare Tool- View Comment should is shown in script, though Include Comments option unchecked

Dev	tomconrad
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	Hive
Version	19.0

Aqua Data Studio 15.0.0-dev-295
Build #: 38083
Built on: 2014-May-22 04:40:25 PM

Operating Environment: Ubuntu 13.04 LTS

Database: Cloudera Impala
CDH 5 VM , Connection Type: Impala , Port: 21050
Java Version: Java 1.7.0_51

Issue: Impala- Schema Compare Tool- Comment should not be shown in script, when Include Comments option unchecked

Steps to reproduce:

Start Cloudera Quickstart VM CDH5 [or you can use other Cloudera version ]
1. Run below scripts on Query Analyzer

CREATE DATABASE dbimpala

USE dbimpala

CREATE TABLE dbimpala.perm (

a int,

b string)

ROW FORMAT DELIMITED

STORED AS TEXTFILE

CREATE VIEW `view1`

COMMENT 'view1 comment'

SELECT * FROM perm

2. ADS menubar, go to Tools-> Compare Tools-> Schema Compare.

3. 'Schema Compare Tool' window opens, [Refer Screenshot1]
select Server 1 - Impala- database- dbimpala
select Server 2 - Impala- database- default

4. In options block, Uncheck 'Include Comments' checkbox.
5. In Objects block, select only 'view1' view, click on compare.
6. Schema Compare Results tab opens, click mouse pointer on view1, to select it, it will show the script .

7. The script includes comment for the view 'view1'.

It should not include comment, as we have unchecked 'Include Comments' check box option.

3 attachments

Screenshot1.png

2014-05-27T12:44:36Z

351 KB
check_Include_Comments.png

2017-04-25T12:25:56Z

207 KB
Impala_Uncheck_Include_Comments.png

2017-04-25T12:25:57Z

129 KB

All Comments (3) Change History

tomconrad 2017-04-21T23:01:03Z

svn# 54031 - This was also fixed for table comments. So for the following scenario, table and view comments should turn on and off with the include comments checkbox in Schema Compare.

CREATE TABLE dbimpala.perm  ( 
a int, 
b string)
COMMENT 'table comment'
ROW FORMAT DELIMITED
STORED AS TEXTFILE
GO
 
 
CREATE VIEW `view1`
COMMENT 'view1 comment'
AS 
SELECT * FROM perm
Go

svn# 54031 - This was also fixed for table comments. So for the following scenario, table and view comments should turn on and off with the include comments checkbox in Schema Compare.

CREATE TABLE dbimpala.perm  ( 
a int, 
b string)
COMMENT 'table comment'
ROW FORMAT DELIMITED
STORED AS TEXTFILE
GO
 
 
CREATE VIEW `view1`
COMMENT 'view1 comment'
AS 
SELECT * FROM perm
Go

dutondeumesh 2017-04-25T12:30:18Z

Verified in ADS 19.0.0-dev-27. On and off with the include comments checkbox works fine for table and view.
Verified for hive connection also. please refer impala screenshot below.

Cloudera 5.8 - Impala 2.6[2.5 drivers]

Include comment checked : screenshot
Include comment unchecked : screenshot

tariqrahiman 2017-05-22T17:43:17Z

Verified in ADS v19.0.0-alpha-10

Search Tips

Aqua Data Studio / nhilam

Impala- Schema Compare Tool- View Comment should is shown in script, though Include Comments option unchecked

3 attachments

Issue #12209

Completion

Search Tips

Aqua Data Studio / nhilam

Title

Impala- Schema Compare Tool- View Comment should is shown in script, though Include Comments option unchecked

3 attachments

Issue #12209

Completion