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 <[email protected]> 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 <[email protected]> > 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 <[email protected]> >> 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
