hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Manisha Gayathri <mani...@wso2.com>
Subject ORDER BY does not work with CONCAT operation
Date Fri, 10 Aug 2012 11:03:00 GMT
Hi,

I have a Cassandra Column Family and I need to write some of the data to a
file in the local file system. And the data in the file should be ordered
by the payload_logTime.

Below is the code segment I used to write the data to the file. But still
the data does not get Ordered properly.

INSERT OVERWRITE LOCAL DIRECTORY
home/manisha/Desktop/logDir/logs/0/Application_Server/2012_07_31
select concat(
'Message[',payload_message,']\t',
'Stacktrace ',payload_stacktrace,'\t',
'Logger{',payload_logger,'}\t',
'Priority[',payload_priority,']\t',
(from_unixtime(payload_logTime,'yyyy-MM-dd HH:mm:ss.SSS' )),'\n')  from
LogStats
ORDER BY '_col0';

Appreciate some assistance on this.
Thanks
-- 
~Regards
*Manisha Eleperuma*
Software Engineer
WSO2, Inc.: http://wso2.com
lean.enterprise.middleware

*mobile:  +94 71 8279777*
*
*

Mime
View raw message