Prabhu Joseph created ZEPPELIN-2560:
---------------------------------------
Summary: Zeppelin JDBCInterpreter result has decimal column value
rounded
Key: ZEPPELIN-2560
URL: https://issues.apache.org/jira/browse/ZEPPELIN-2560
Project: Zeppelin
Issue Type: Bug
Components: zeppelin-server
Affects Versions: 0.7.1
Reporter: Prabhu Joseph
Hive / Phoenix query on a table with column having a decimal value is rounded.
JDBCInterpreter is having correct data in InterpreterResult but while
displaying looks Zeppelin rounding the data. There should be some configuration
to enable/disable this or set the number of decimals needed.
Repro:
{code}
[root@bigdata1 zeppelin]# cat /tmp/data
123.45678999,123.45678999,123.456789
hive>create table dec4 (key string,c1 string, c2 decimal(10,7)) row format
delimited fields terminated by ",";
hive>load data local inpath '/tmp/data' into table dec4;
hive> select * from dec4;
OK
123.45678999 123.45678999 123.456789
Time taken: 0.632 seconds, Fetched: 1 row(s)
>From Zeppelin:
%jdbc(hive)
select * from dec4
123.45679 123.45679 123.45679
{code}
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)