You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Victoria Markman (JIRA)" <ji...@apache.org> on 2015/01/29 18:08:34 UTC
[jira] [Commented] (DRILL-2110) all_text_mode for json works only
with alter system not with alter session
[ https://issues.apache.org/jira/browse/DRILL-2110?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14297142#comment-14297142 ]
Victoria Markman commented on DRILL-2110:
-----------------------------------------
This is duplicate of DRILL-1953
> 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
> Attachments: AlterSystemVsAlterSessionJson.rtf
>
>
> 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)