You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by Luke Han <lu...@gmail.com> on 2015/03/21 07:16:12 UTC
Fwd: Dup key found
Forward to dev mailing list
在 2015年3月20日星期五 UTC-7下午10:54:02，futur...@gmail.com写道：
>
> [ERROR][com.kylinolap.job.hadoop.dict.CreateDictionaryJob.run(CreateDictionaryJob.java:55)]
> - Dup key found, key=[352571034729600],
> value1=[2012-11-20,1010029,88192991552515,352571034729600,01,8314,01,779.00,0],
> value2=[2012-11-20,1020002,88192991552515,352571034729600,01,8314,01,779.00,0]
> java.lang.IllegalStateException: Dup key found, key=[352571034729600],
> value1=[2012-11-20,1010029,88192991552515,352571034729600,01,8314,01,779.00,0],
> value2=[2012-11-20,1020002,88192991552515,352571034729600,01,8314,01,779.00,0]
> at
> com.kylinolap.dict.lookup.LookupTable.initRow(LookupTable.java:79)
> at com.kylinolap.dict.lookup.LookupTable.init(LookupTable.java:62)
> at
> com.kylinolap.dict.lookup.LookupTable.<init>(LookupTable.java:50)
> at
> com.kylinolap.dict.lookup.LookupStringTable.<init>(LookupStringTable.java:30)
>
>
Re: Dup key found
Posted by hongbin ma <ma...@apache.org>.
Kylin does requires primary keys on look table to be unique.
In your case, the column which holds the value "352571034729600" is not
unique. please clean up your lookup table if possible
On Fri, Mar 20, 2015 at 11:16 PM, Luke Han <lu...@gmail.com> wrote:
> Forward to dev mailing list
>
> 在 2015年3月20日星期五 UTC-7下午10:54:02，futur...@gmail.com写道：
>>
>> [ERROR][com.kylinolap.job.hadoop.dict.CreateDictionaryJob.run(CreateDictionaryJob.java:55)]
>> - Dup key found, key=[352571034729600], value1=[2012-11-20,1010029,
>> 88192991552515,352571034729600,01,8314,01,779.00,0],
>> value2=[2012-11-20,1020002,88192991552515,352571034729600,01,8314,01,
>> 779.00,0]
>> java.lang.IllegalStateException: Dup key found, key=[352571034729600],
>> value1=[2012-11-20,1010029,88192991552515,352571034729600,01,8314,01,779.00,0],
>> value2=[2012-11-20,1020002,88192991552515,352571034729600,01,8314,01,
>> 779.00,0]
>> at com.kylinolap.dict.lookup.LookupTable.initRow(
>> LookupTable.java:79)
>> at com.kylinolap.dict.lookup.LookupTable.init(LookupTable.
>> java:62)
>> at com.kylinolap.dict.lookup.LookupTable.<init>(
>> LookupTable.java:50)
>> at com.kylinolap.dict.lookup.LookupStringTable.<init>(
>> LookupStringTable.java:30)
>>
>>
--
Regards,
*Bin Mahone | 马洪宾*
Apache Kylin: http://kylin.io
Github: https://github.com/binmahone