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
Aqua Data Studio 17.0.0-rc-36
Build #: 47049
Built on: 2015-Nov-16 05:39:20 PM
OS: Ubuntu 14.04
Linux (3.13.0-59-generic, amd64) / UTF-8 / en / IN / Oracle Corporation 1.8.0_40-b26
Memory: Max=704,643,072; Total=578,813,952; Free=226,655,184; CPUs=8
Issue: Hive-> Partitioned columns are displayed twice in auto-completion
This issue is introduced due to changes made for issue #13857
Steps:
1. Create table using below script.
CREATE TABLE `default`.`sale` (
`divisionid` tinyint)
PARTITIONED BY (sk_calendar int)
STORED AS ORC
TBLPROPERTIES ('orc.compress'='NONE')
2. Open query analyzer, write below statement
select from sale
3. In above statement, after select keyword, after a space, put cursor pointer.
4. Press CTRL+Space keys for autocompletion, Autocompletion pop-up displays partitioned column twice. <-- Issue - scenario 1
Or
5. In ADS Menu bar - select Automate options <-- Issue - scenario 2
Menu bar - Automate-> Introduce Columns - partitioned column inserted twice
Menu bar - Automate-> Introduce Qualified Columns - partitioned column inserted twice
Menu bar - Automate-> Introduce Value Stubs - 3 values generated
Please refer screenshot1.png
|
|
129 KB
|
|
160 KB
|
|
224 KB
|
|
209 KB
|
|
133 KB
|
|
93 KB
Hi Anil, This doesn't appear to be related to 13857. Different code. Looks like this has been around for a while. When doing a describe, the partition columns appear as regular columns and also appear as partition columns. I only tested the fix with HDP and Impala. Please try it with different hives and Spark.. Thank you, Tom
Verified in ADS17.0.0-rc-38
Please refer screenshot: Fixed13858.png
Verified in ADS17.0.0-rc-38
Please refer screenshot: Fixed13858.png
Verified in ADS17.0.0-rc-49
Tested on
a] MapR 5.0.0 Hive 1.0.0
b] MapR 5.0.0-Spark-SQL 1.5.0
Please refer screenshot:
a] Fixed-17rc49.png [Spark-SQL]
b] Fixed-17rc49-Hive.png [Hive]
Verified in ADS17.0.0-rc-49
Tested on
a] MapR 5.0.0 Hive 1.0.0
b] MapR 5.0.0-Spark-SQL 1.5.0
Please refer screenshot:
a] Fixed-17rc49.png [Spark-SQL]
b] Fixed-17rc49-Hive.png [Hive]
Verified in ADS v18.0.0-dev-38
Verified in ADS v18.0.0-dev-38
Verified in ADS-18.0-DEV-39. Please refer: 13858.png
Verified in ADS-18.0-DEV-39. Please refer: 13858.png
Issue #13858 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build ADS 18.0.0-dev-14 & ADS 17.0.0-rc-38 |
| No time estimate |
Hi Anil, This doesn't appear to be related to 13857. Different code. Looks like this has been around for a while. When doing a describe, the partition columns appear as regular columns and also appear as partition columns. I only tested the fix with HDP and Impala. Please try it with different hives and Spark.. Thank you, Tom