[
https://issues.apache.org/jira/browse/HIVE-994?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12791391#action_12791391
]
Nhan Nguyen commented on HIVE-994:
----------------------------------
Hi Steinbach,
Thanks for looking into this problem. Here's the complete output of your
requested queries
{code}
hive> select * from staff;
OK
1 Peter
2 Mary
3 John
Time taken: 0.138 seconds
hive> select * from staff where name="Peter";
Total MapReduce jobs = 1
Launching Job 1 out of 1
Number of reduce tasks is set to 0 since there's no reduce operator
Starting Job = job_200912152159_0006, Tracking URL =
http://hadoop-1:50030/jobdetails.jsp?jobid=job_200912152159_0006
Kill Command = /data/hadoop-hive/bin/../bin/hadoop job
-Dmapred.job.tracker=hadoop-1:51444 -kill job_200912152159_0006
2009-12-16 02:23:18,695 Stage-1 map = 0%, reduce = 0%
2009-12-16 02:23:33,808 Stage-1 map = 55%, reduce = 0%
2009-12-16 02:23:36,836 Stage-1 map = 64%, reduce = 0%
2009-12-16 02:23:39,859 Stage-1 map = 100%, reduce = 0%
2009-12-16 02:23:42,883 Stage-1 map = 100%, reduce = 100%
Ended Job = job_200912152159_0006
OK
Time taken: 26.58 seconds
hive> describe extended staff;
OK
id bigint
name string
Detailed Table Information Table(tableName:staff, dbName:default,
owner:hive, createTime:1260958974, lastAccessTime:0, retention:0,
sd:StorageDescriptor(cols:[FieldSchema(name:id, type:bigint, comment:null),
FieldSchema(name:name, type:string, comment:null)],
location:hdfs://hadoop-1:51000/staff,
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=9,line.delim=
,field.delim= }), bucketCols:[], sortCols:[], parameters:{}),
partitionKeys:[], parameters:{transient_lastDdlTime=1260958974})
Time taken: 0.081 seconds
{code}
I believe this has nothing to do with Hadoop as when I switch back to Hive
stable release 0.4.0 with hive-default.xml copied from my current Hive, string
comparison just works perfectly.
Thanks,
> String comparison stopped working on trunk code
> -----------------------------------------------
>
> Key: HIVE-994
> URL: https://issues.apache.org/jira/browse/HIVE-994
> Project: Hadoop Hive
> Issue Type: Bug
> Environment: Hadoop v0.20.1 and latest Hive from trunk
> Reporter: Nhan Nguyen
> Priority: Critical
>
> Comparing string field with specified value always yield no match.
> E.g,
> Table staff
> ||id||name||
> |1|Peter|
> |2|Mary|
> |3|John|
> query:
> {code}
> select * from staff where name="Peter";
> {code}
> yield no match.
> Hive stable version with the same configuration works correctly.
> Please help troubleshooting it.
> Thanks,
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
