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.thong...@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.thong...@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
