hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nhan Nguyen (JIRA)" <j...@apache.org>
Subject [jira] Commented: (HIVE-994) String comparison stopped working on trunk code
Date Wed, 16 Dec 2009 15:05:18 GMT

    [ 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.


Mime
View raw message