drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Victoria Markman (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (DRILL-2110) all_text_mode for json works only with alter system not with alter session
Date Thu, 29 Jan 2015 23:06:34 GMT

     [ https://issues.apache.org/jira/browse/DRILL-2110?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Victoria Markman resolved DRILL-2110.
-------------------------------------
    Resolution: Duplicate

> 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)

Mime
View raw message