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 10:46:16 GMT
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

Mime
View raw message