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
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
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
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
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
Hi,
The query result
11236119012.64043-5.9708868.5592070.0 0.0
0.0-19.6869931308.804799848.00.006196644 0.00.0
301.274750.382470460.0NULL11 20081
11236122012.513598-6.36717137.3927946 0.0