Aqua Data Studio 16.0.0-dev-74
Build #: 41480
Built on: 2014-Dec-12 06:20:38 PM

Database : Cloudera Impala
CDH 5.2.0 VM , hive 0.13 driver, Connection Type: Impala , Port: 21050
Java Version: Java 1.7.0_60

Steps to reproduce:

1. Connect to impala server

2. Go to any database --> Tables folder

3. Right click and Select Create Table option

4. In Create Table window, write table name

5. Add a column with decimal datatype.

Here for decimal datatype, default precision and scale values are not defined.

In preview sql tab, shows error message “Invalid : decimal data types require a precision”.

As per documentation, in impala for decimal datatype default precision and scale value is (9,0).

So can we have default values of precision and scale are set by deafult ?

OR

Impala allows to add column of decimal datatype with no precision or scale value and it is equivalent to decimal(9,0).

So can we allow to add column of decimal datatype without specifying precision value .

Please see attached screenshot.