[jira] [Created] (DRILL-2110) all_text_mode for json works only with alter system not with alter session

["Sudhakar Thota (JIRA)" <ji...@apache.org>]

Sudhakar Thota created DRILL-2110:
-------------------------------------

             Summary: all_text_mode for json works only with alter system not with alter session
                 Key: DRILL-2110
                 URL: https://issues.apache.org/jira/browse/DRILL-2110
             Project: Apache Drill
          Issue Type: Bug
          Components: Client - CLI
    Affects Versions: 0.7.0
         Environment: MapR 4.0.2 sandbox
            Reporter: Sudhakar Thota
            Assignee: Jacques Nadeau


1. alter session set `store.json.all_text_mode` = true;
fails to show the json document but 
alter system set `store.json.all_text_mode` = true;
shows the documents on MapR 4.0.2 sandbox with drill-0.7. 

2. Exhibiting same behavior with Drill Explorer. 
-----------------------------
[root@maprdemo ~]# ls -l /tmp/anonym.json 
-rwxr-xr-x 1 root root 9966583 Jan 28 18:26 /tmp/anonym.json
[root@maprdemo christian]# pwd
/mapr/demo.mapr.com/user/sthota/christian
[root@maprdemo christian]# cp /tmp/anonym.json .
[root@maprdemo christian]# ls -l /mapr/demo.mapr.com/user/sthota/christian/anonym.json 
-rwxr-xr-x 1 root root 9966583 Jan 28 18:28 /mapr/demo.mapr.com/user/sthota/christian/anonym.json
[root@maprdemo christian]# su - mapr
[mapr@maprdemo ~]$ sqlline
sqlline version 1.1.6
0: jdbc:drill:> show databases;
+-------------+
| SCHEMA_NAME |
+-------------+
| hive.default |
| dfs.default |
| dfs.logs    |
| dfs.root    |
| dfs.views   |
| dfs.clicks  |
| dfs.tmp     |
| sys         |
| maprdb      |
| cp.default  |
| INFORMATION_SCHEMA |
+-------------+
11 rows selected (0.222 seconds)
0: jdbc:drill:> select * from dfs.`/user/sthota/christian/anonym.json` limit 4;
Query failed: Query stopped., You tried to write a BigInt type when you are using a ValueWriter of type NullableFloat8WriterImpl. [ e3a8c338-ba88-435c-b7d4-7b8d60d61fb4 on maprdemo:31010 ]


Error: exception while executing query: Failure while executing query. (state=,code=0)
0: jdbc:drill:> alter session set `store.json.all_text_mode`=true;
+------------+------------+
|     ok     |  summary   |
+------------+------------+
| true       | store.json.all_text_mode updated. |
+------------+------------+
1 row selected (0.088 seconds)
0: jdbc:drill:> 

0: jdbc:drill:> alter system set `store.json.all_text_mode`=true;
+------------+------------+
|     ok     |  summary   |
+------------+------------+
| true       | store.json.all_text_mode updated. |
+------------+------------+
1 row selected (0.064 seconds)
0: jdbc:drill:> select * from dfs.`/user/sthota/christian/anonym.json` limit 4;
+------------+------------+------------+------------+------------+------------+
|     eq     |     tm     |    seq     |    guid    |    val     |    log     |
+------------+------------+------------+------------+------------+------------+
| in4ktVxSI  | 1336177774.84 | 108        | 61429740-6d15-165e-3388-c6d4e19af9c1 | …….. |
+------------+------------+------------+------------+------------+------------+
4 rows selected (0.997 seconds)
0: jdbc:drill:> 

----------------------



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)