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
Customer request..
Create a hive table as per below
CREATE TABLE `default`.`sale` (
`divisionid` tinyint)
PARTITIONED BY (sk_calendar int)
STORED AS ORC
TBLPROPERTIES ('orc.compress'='NONE')
When you script the table with “Select” it does not include the partitioned column which it should.
Result of script select
SELECT `divisionid`
FROM `sale`
Select * from FROM `sale` shows 2 columns
The partitioned column(s) should be the last column(s) in the select clause.
|
|
138 KB
|
|
101 KB
|
669 B
|
|
227 B
|
|
187 KB
|
|
60 KB
|
|
74 KB
Hi QA team, The partitioned columns should now be at the end of the script select. Please test the script select across Hive, Spark and Impala... Thanks in advance, Tom
Build: ADS17.0.0-rc-36
@Tariq
The partitioned columns displayed at the end of the script 'select'.
Please refer Fixed13857.png
This fix caused new issue- We will test this issue again, once below issue is fixed.
Then we can mark this issue as Verified.
In select statement for autocompletion of columns- partitioned columns are displayed twice.
Logged issue for this behaviour- Issue #13858
Build: ADS17.0.0-rc-36
@Tariq
The partitioned columns displayed at the end of the script 'select'.
Please refer Fixed13857.png
This fix caused new issue- We will test this issue again, once below issue is fixed.
Then we can mark this issue as Verified.
In select statement for autocompletion of columns- partitioned columns are displayed twice.
Logged issue for this behaviour- Issue #13858
Verified in ADS17.0.0-rc-38
Please refer attachments.
Also attached SQL script and table data.
Verified in ADS17.0.0-rc-38
Please refer attachments.
Also attached SQL script and table data.
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: Fixed-17rc49.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: Fixed-17rc49.png
Verified in ADS v18.0.0-dev-38
Verified in ADS v18.0.0-dev-38
Verified in ADS-18-DEV-39. Please refer: 13857.png
Verified in ADS-18-DEV-39. Please refer: 13857.png
Issue #13857 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build ADS 18.0.0-dev-14 & ADS 17.0.0-rc-36 |
| No time estimate |
Hi QA team, The partitioned columns should now be at the end of the script select. Please test the script select across Hive, Spark and Impala... Thanks in advance, Tom