[
https://issues.apache.org/jira/browse/HIVE-11332?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sergey Shelukhin updated HIVE-11332:
------------------------------------
Description:
Noticed by accident.
{noformat}
select '😾 ', count(*) from moo;
Query ID = sershe_20150721190413_979e1b6f-86d6-436f-b8e6-d6785b9d3b83
Total jobs = 1
Launching Job 1 out of 1
[snip]
OK
😾 0
Time taken: 13.347 seconds, Fetched: 1 row(s)
hive> ALTER TABLE moo SET TBLPROPERTIES ('comment' = '😾 ');
OK
Time taken: 0.292 seconds
hive> desc extended moo;
OK
i int
Detailed Table Information Table(tableName:moo, dbName:default,
owner:sershe, createTime:1437519787, lastAccessTime:0, retention:0,
sd:StorageDescriptor(cols:[FieldSchema(name:i, type:int, comment:null)],
location:hdfs://cn108-10.l42scl.hortonworks.com:8020/apps/hive/warehouse/moo,
inputFormat:org.apache.hadoop.mapred.TextInputFormat,
outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat,
compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null,
serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe,
parameters:{serialization.format=1}), bucketCols:[], sortCols:[],
parameters:{}, skewedInfo:SkewedInfo(skewedColNames:[], skewedColValues:[],
skewedColValueLocationMaps:{}), storedAsSubDirectories:false),
partitionKeys:[], parameters:{last_modified_time=1437519883, totalSize=0,
numRows=-1, rawDataSize=-1, COLUMN_STATS_ACCURATE=false, numFiles=0,
transient_lastDdlTime=1437519883, comment=?? , last_modified_by=sershe},
viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
Time taken: 0.347 seconds, Fetched: 3 row(s)
{noformat}
was:
Noticed by accident.
{noformat}
select '😾 ', count(*) from moo;
Query ID = sershe_20150721190413_979e1b6f-86d6-436f-b8e6-d6785b9d3b83
Total jobs = 1
Launching Job 1 out of 1
[snip]
OK
😾 0
Time taken: 13.347 seconds, Fetched: 1 row(s)
hive> ALTER TABLE moo SET TBLPROPERTIES ('comment' = '😾' ');
OK
Time taken: 0.292 seconds
hive> desc extended moo;
OK
i int
Detailed Table Information Table(tableName:moo, dbName:default,
owner:sershe, createTime:1437519787, lastAccessTime:0, retention:0,
sd:StorageDescriptor(cols:[FieldSchema(name:i, type:int, comment:null)],
location:hdfs://cn108-10.l42scl.hortonworks.com:8020/apps/hive/warehouse/moo,
inputFormat:org.apache.hadoop.mapred.TextInputFormat,
outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat,
compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null,
serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe,
parameters:{serialization.format=1}), bucketCols:[], sortCols:[],
parameters:{}, skewedInfo:SkewedInfo(skewedColNames:[], skewedColValues:[],
skewedColValueLocationMaps:{}), storedAsSubDirectories:false),
partitionKeys:[], parameters:{last_modified_time=1437519883, totalSize=0,
numRows=-1, rawDataSize=-1, COLUMN_STATS_ACCURATE=false, numFiles=0,
transient_lastDdlTime=1437519883, comment=?? , last_modified_by=sershe},
viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
Time taken: 0.347 seconds, Fetched: 3 row(s)
{noformat}
> Unicode table comments do not work
> ----------------------------------
>
> Key: HIVE-11332
> URL: https://issues.apache.org/jira/browse/HIVE-11332
> Project: Hive
> Issue Type: Bug
> Reporter: Sergey Shelukhin
>
> Noticed by accident.
> {noformat}
> select '😾 ', count(*) from moo;
> Query ID = sershe_20150721190413_979e1b6f-86d6-436f-b8e6-d6785b9d3b83
> Total jobs = 1
> Launching Job 1 out of 1
> [snip]
> OK
> 😾 0
> Time taken: 13.347 seconds, Fetched: 1 row(s)
> hive> ALTER TABLE moo SET TBLPROPERTIES ('comment' = '😾 ');
> OK
> Time taken: 0.292 seconds
> hive> desc extended moo;
> OK
> i int
>
> Detailed Table Information Table(tableName:moo, dbName:default,
> owner:sershe, createTime:1437519787, lastAccessTime:0, retention:0,
> sd:StorageDescriptor(cols:[FieldSchema(name:i, type:int, comment:null)],
> location:hdfs://cn108-10.l42scl.hortonworks.com:8020/apps/hive/warehouse/moo,
> inputFormat:org.apache.hadoop.mapred.TextInputFormat,
> outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat,
> compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null,
> serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe,
> parameters:{serialization.format=1}), bucketCols:[], sortCols:[],
> parameters:{}, skewedInfo:SkewedInfo(skewedColNames:[], skewedColValues:[],
> skewedColValueLocationMaps:{}), storedAsSubDirectories:false),
> partitionKeys:[], parameters:{last_modified_time=1437519883, totalSize=0,
> numRows=-1, rawDataSize=-1, COLUMN_STATS_ACCURATE=false, numFiles=0,
> transient_lastDdlTime=1437519883, comment=?? , last_modified_by=sershe},
> viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
> Time taken: 0.347 seconds, Fetched: 3 row(s)
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
