Current version of ADS uses the default "INPUT/OUTPUT FORMAT" in the "Stored As" field under the "Storage" tab when using Alter Table or Table Properties. It is not clear when changes happen since the default "INPUT/OUTPUT FORMAT" is always used. Input and output format handler classes will change but that is not always obvious. Since the handlers vary, we will attempt to map the "Stored As" field to the most common handler formats:
|
142 KB
|
78 KB
|
88 KB
|
154 KB
|
87 KB
|
107 KB
|
85 KB
"INPUT/OUTPUT FORMAT <See below...>"
Change this to:
<See below for INPUT and OUTPUT Formats>
Hi Anil, I used the following storage handler classes. They seem to be the default for output. Can you think of any others that we should add? Thanks, Tom
Hi Anil, I used the following storage handler classes. They seem to be the default for output. Can you think of any others that we should add? Thanks, Tom
Reopening the issue,
In ADS18.0.0-dev-6 build, Stored As field is not reflected with selected Table Format. - [Reopened].
Please refer screenshot: Reopened-ADS18-dev-6.png
-- In ADS17.0.0-rc-22 build, Stored As field is reflected with selected Table Format as TEXTFILE- [Verified]
Reopening the issue,
In ADS18.0.0-dev-6 build, Stored As field is not reflected with selected Table Format. - [Reopened].
Please refer screenshot: Reopened-ADS18-dev-6.png
-- In ADS17.0.0-rc-22 build, Stored As field is reflected with selected Table Format as TEXTFILE- [Verified]
Verified in ADS 17.0.0-rc-24
and ADS 18.0.0-dev-10
Please refer screenshot: Fixed13791.png
Verified in ADS 17.0.0-rc-24
and ADS 18.0.0-dev-10
Please refer screenshot: Fixed13791.png
Verified in ADS17.0.0-rc-51
Checked for MapR Hive 1.0.0 and Spark1.5.0
Please refer screnshots- 1TableAlter and 2ERD-Seq
Verified in ADS17.0.0-rc-51
Checked for MapR Hive 1.0.0 and Spark1.5.0
Please refer screnshots- 1TableAlter and 2ERD-Seq
Verified in ADS-18.0.0-RC-16. Refer updated screenshot 'Updated_13791.png'
Verified in ADS-18.0.0-RC-16. Refer updated screenshot 'Updated_13791.png'
Issue #13791 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build ADS 18.0.0-dev-7 |
No time estimate |
2 issue links |
relates to #13794
Issue #13794"Stored As" field mapping improvement |
relates to #13768
Issue #13768Spark-SQL- In Alter Table-Storage Tab- Stored As field should display Table Storage Format |
Change this to:
<See below for INPUT and OUTPUT Formats>