[SPARK-26969] [Spark] Using ODBC not able to see the data in table when datatype is decimal

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.4.0
• Fix Version/s: 3.0.0
• Component/s: Spark Shell
• Assignee: Sujith Chacko
• Reporter: ABHISHEK KUMAR GUPTA
• Created: 22/Feb/19 09:58
• Updated: 13/Aug/19 13:10
• Resolved: 12/Aug/19 22:49

Description

#  Using odbc rpm file install odbc 
 # connect to odbc using isql -v spark2xsingle
 # SQL> create table t1_t(id decimal(15,2));
 # SQL> insert into t1_t values(15);
 # 
SQL> select * from t1_t;
+-------------------------+
| id |
+-------------------------+
+-------------------------+  Actual output is empty

Note: When creating table of int data type select is giving result as below

SQL> create table test_t1(id int);
SQL> insert into test_t1 values(10);
SQL> select * from test_t1;
+------------+
| id         |
+------------+
| 10         |
+------------+

Needs to handle for decimal case.

Issue Links

• links to: GitHub Pull Request #23899