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)