hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From pth001 <Patcharee.Thong...@uni.no>
Subject Re: character '' not supported here
Date Sat, 18 Jul 2015 18:35:23 GMT
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 
> <mailto: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 <mailto: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


Mime
View raw message