On Mar 13, 2012, at 13:57 , Igor Tatarinov wrote:
> You have attributevalue in quotes which makes it a constant literal.
>
> igor
> decide.com
Argh! You are correct good sir!
Keith Wiley kwi...@keithwiley.c
This syntax is wrong for both hive and SQL:
hive> select * from stringmap where attributename='foo' order by
'attributevalue';
This is right.
hive> select * from stringmap where attributename='foo' order by attributevalue;
On Tue, Mar 13, 2012 at 4:54 PM, Keith Wiley wrote:
> Um, this is weird.
March 13, 2012 4:54:05 PM
Subject: order by having no effect?!
Um, this is weird. It simply isn't modifying the order of the returned rows at
all. I get the same result with no 'order by' clause as with one. Adding a
limit or specifying 'asc' has no effect. Using &#x
You have attributevalue in quotes which makes it a constant literal.
igor
decide.com
On Tue, Mar 13, 2012 at 1:54 PM, Keith Wiley wrote:
> Um, this is weird. It simply isn't modifying the order of the returned
> rows at all. I get the same result with no 'order by' clause as with one.
> Addi
Um, this is weird. It simply isn't modifying the order of the returned rows at
all. I get the same result with no 'order by' clause as with one. Adding a
limit or specifying 'asc' has no effect. Using 'sort by' also has no effect.
The column used for ordering is type INT. In the example be
