Hi,
I created a hive table stored as orc file (partitioned and compressed by
ZLIB) from Hive CLI, added data into this table by a Spark application.
After adding I was able to query data and everything looked fine. Then I
concatenated the table from Hive CLI. After that I am not able to query
data, like select count(*) from Table, any more, just got error line 1:1
character '' not supported here, no matter Tez or MR engine.
How can you solve the problem in your case?
BR,
Patcharee
On 18. juli 2015 21:26, Nitin Pawar wrote:
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.thong...@uni.no
<mailto:patcharee.thong...@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.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
--
Nitin Pawar
