character set support && hive 1.1.0(or 1.2.0) support

[王贤良 <se...@live.cn>]

hello:
    for a hive table, the query is:
    select * from dim_province where province_name ='北京';
    SYSTEM ERROR: org.apache.calcite.runtime.CalciteException: Failed to encode '北京' in character set 'ISO-8859-1'
    how to set utf-8?
 
    for hive 1.1.0( or 1.2.0), a pqrauet table ,the column's type is varchar( or timestamp), the error is :
    SYSTEM ERROR: java.lang.UnsupportedOperationException: Parquet does not support varchar. See HIVE-6384
    how to support?

Thanks

Re: character set support && hive 1.1.0(or 1.2.0) support

[Hao Zhu <hz...@maprtech.com>]

1.

0: jdbc:drill:zk=h2.poc.com:5181,h3.poc.com:5> select * from `chinese.csv`;
+---------------------+
|       columns       |
+---------------------+
| ["北京","1","2","3"]  |
+---------------------+
1 row selected (0.093 seconds)

0: jdbc:drill:zk=h2.poc.com:5181,h3.poc.com:5> select columns[2] from
`chinese.csv` where columns[0]= _UTF16'北京';
+---------+
| EXPR$0  |
+---------+
| 2       |
+---------+
1 row selected (0.115 seconds)

*I would suggest put above in documentation.*

2.

Drill 1.0 supports hive 0.13 storage plugin.
http://drill.apache.org/docs/hive-storage-plugin/
Hive 1.x should be in future roadmap.

Thanks,
Hao


On Wed, May 20, 2015 at 3:30 AM, 王贤良 <se...@live.cn> wrote:

> hello:
>     for a hive table, the query is:
>     select * from dim_province where province_name ='北京';
>     SYSTEM ERROR: org.apache.calcite.runtime.CalciteException: Failed to
> encode '北京' in character set 'ISO-8859-1'
>     how to set utf-8?
>
>     for hive 1.1.0( or 1.2.0), a pqrauet table ,the column's type is
> varchar( or timestamp), the error is :
>     SYSTEM ERROR: java.lang.UnsupportedOperationException: Parquet does
> not support varchar. See HIVE-6384
>     how to support?
>
> Thanks
>