Remove Date datatype from Cloudera ER Modeler.
Creating an ER Modeler with Date and executing in the Query Analyzer gives
SemanticException [Error 10099]: DATE and DATETIME types aren't supported yet. Please use TIMESTAMP instead
Also ADS 15.0.0-dev-293
Aqua Data Studio 15.0.0-dev-293
Build #: 38042
Built on: 2014-May-21 03:57:10 PM
Cloudera Quickstart VM CDH5 [Hive 0.12] , Distribution: Cloudera, Connection Type: Hiveserver2
When ADS is connected with Cloudera Hive 0.12, In create table visual editor and in ERD table column datatype drop down list, it doesn't show Date datatype.
But As Cloudera Hive 0.12 supports 'Date' datatype, it should be listed. currently it has been removed.
The particular datatype should be removed only, if it doesn't support that Hive Version.
Please refer the document which has all this required details.
Document: ClouderaHiveDatatypesDetails
Aqua Data Studio 15.0.0-dev-293
Build #: 38042
Built on: 2014-May-21 03:57:10 PM
Cloudera Quickstart VM CDH5 [Hive 0.12] , Distribution: Cloudera, Connection Type: Hiveserver2
When ADS is connected with Cloudera Hive 0.12, In create table visual editor and in ERD table column datatype drop down list, it doesn't show Date datatype.
But As Cloudera Hive 0.12 supports 'Date' datatype, it should be listed. currently it has been removed.
The particular datatype should be removed only, if it doesn't support that Hive Version.
Please refer the document which has all this required details.
Document: ClouderaHiveDatatypesDetails
This issue is still observed in ADS 14.0.15 build.
Please refer above comment [ dated May 22, 2014 ]
This issue is still observed in ADS 14.0.15 build.
Please refer above comment [ dated May 22, 2014 ]
@anil: create a separate issue which tracks all items that need to be back ported to ads v14
@anil: create a separate issue which tracks all items that need to be back ported to ads v14
Verified in ADS 15.0.0-dev-372,
Will test on ADS 14.0.18 patch , when available.
Verified in ADS 15.0.0-dev-372,
Will test on ADS 14.0.18 patch , when available.
Verified in ADS 14.0.18
and ADS 15.0.0-alpha-17
Verified on all supported Hive Distributions.
'Date' datatype is shown only for the supported Hive version.
Verified in ADS 14.0.18
and ADS 15.0.0-alpha-17
Verified on all supported Hive Distributions.
'Date' datatype is shown only for the supported Hive version.
Verified in ADS 16.0.0-dev-21
Verified in ADS 16.0.0-dev-21
Issue #12169 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build ADS 15.0.0-dev-353 |
No time estimate |
Also ADS 15.0.0-dev-293