You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Sudhakar Thota (JIRA)" <ji...@apache.org> on 2015/01/29 04:04:34 UTC
[jira] [Created] (DRILL-2110) all_text_mode for json works only
with alter system not with alter session
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)