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.thong...@uni.no
<mailto: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 <mailto: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