hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nitin Pawar <nitinpawar...@gmail.com>
Subject Re: character '' not supported here
Date Sat, 18 Jul 2015 19:26:47 GMT
can you tell exactly what steps you did/?
also did you try running the query with processing to MR instead of tez?
not sure this issue with orc file formats .. i had once faced issues on
alter table for orc backed tabled on adding a new column

On Sun, Jul 19, 2015 at 12:05 AM, pth001 <Patcharee.Thongtra@uni.no> wrote:

>  Hi,
>
> The query result>
>
> 1    12    361    190    12.64043    -5.970886    8.559207    0.0
> 0.0    0.0    -19.686993    1308.8047    99848.0    0.006196644    0.0
> 0.0    301.27475    0.38247046    0.0    NULL    1    1    2008    1
> 1    12    361    220    12.513598    -6.3671713    7.3927946    0.0
> 0.0    0.0    -22.300392    1441.0547    99848.0    0.0050846506    0.0
> 0.0    112.20787    0.30459523    0.0    NULL    1    1    2008    1
> 5    12    250    368    2415.195    5.172235    4.9027147
> -0.024408612    0.0    23590.553    -38.96928    -1130.0469    74660.54
> 2.5969802E-4    9.706164E-11    23054.268    0.0    0.24196737    0.0
> NULL    1    1    2008    1
> 9    12    144    94    12.251964    12.081688    -9.59462    0.0
> 0.0    0.0    -25.93576    258.65625    99848.0    0.0021708217    0.0
> 0.0    1.2963213    1.1560266    0.0    NULL    1    1    2008    1
> 9    12    145    84    12.302098    7.752461    -12.183463    0.0
> 0.0    0.0    -24.983763    351.1953    99848.0    0.0023723599    0.0
> 0.0    1.4137375    0.99239886    0.0    NULL    1    1    2008    1
>
> I stored table in orc format, partitioned and compressed by ZLIB. The
> problem happened just after I concatenate table.
>
> BR,
> Patcharee
>
> On 18/07/15 12:46, Nitin Pawar wrote:
>
>  select * without where will work because it does not involve file
> processing
>  I suspect the problem is with field delimiter so i asked for records so
> that we can see whats the data in each column
>
>  are you using csv file with columns delimited by some char and it has
> numeric data in quotes ?
>
> On Sat, Jul 18, 2015 at 3:58 PM, patcharee <Patcharee.Thongtra@uni.no>
> wrote:
>
>>  This select * from table limit 5; works, but not others. So?
>>
>> Patcharee
>>
>>
>> On 18. juli 2015 12:08, Nitin Pawar wrote:
>>
>> can you do select * from table limit 5;
>>
>> On Sat, Jul 18, 2015 at 3:35 PM, patcharee <Patcharee.Thongtra@uni.no>
>> wrote:
>>
>>> Hi,
>>>
>>> I am using hive 0.14 with Tez engine. Found a weird problem. Any
>>> suggestions?
>>>
>>> hive> select count(*) from 4D;
>>> line 1:1 character '' not supported here
>>> line 1:2 character '' not supported here
>>> line 1:3 character '' not supported here
>>> line 1:4 character '' not supported here
>>> line 1:5 character '' not supported here
>>> line 1:6 character '' not supported here
>>> line 1:7 character '' not supported here
>>> line 1:8 character '' not supported here
>>> line 1:9 character '' not supported here
>>> ...
>>> ...
>>> line 1:131 character '' not supported here
>>> line 1:132 character '' not supported here
>>> line 1:133 character '' not supported here
>>> line 1:134 character '' not supported here
>>> line 1:135 character '' not supported here
>>> line 1:136 character '' not supported here
>>> line 1:137 character '' not supported here
>>> line 1:138 character '' not supported here
>>> line 1:139 character '' not supported here
>>> line 1:140 character '' not supported here
>>> line 1:141 character '' not supported here
>>> line 1:142 character '' not supported here
>>> line 1:143 character '' not supported here
>>> line 1:144 character '' not supported here
>>> line 1:145 character '' not supported here
>>> line 1:146 character '' not supported here
>>>
>>> BR,
>>> Patcharee
>>>
>>>
>>>
>>
>>
>> --
>> Nitin Pawar
>>
>>
>>
>
>
> --
> Nitin Pawar
>
>
>


-- 
Nitin Pawar

Mime
View raw message