RE: 答复: Does Trafodion support to use 'order by' in a subquery

2016-03-24 Thread Anoop Sharma
.@esgyn.com> >, user@trafodion.incubator.apache.org <mailto:user@trafodion.incubator.apache.org> Subject: 答复: Does Trafodion support to use 'order by' in a subquery Thanks Rohit, That is good to know, after think it again, yes, this is wrong in the first place. I tested in Hi

RE: 答复: Does Trafodion support to use 'order by' in a subquery

2016-03-24 Thread Rohit
(Ming)" <ming@esgyn.cn> Date: 03/24/2016 8:42 AM (GMT-06:00) To: Rohit Jain <rohit.j...@esgyn.com>, user@trafodion.incubator.apache.org Subject: 答复: Does Trafodion support to use 'order by' in a subquery Thanks Rohit,   That is good to know, after think it again, yes, this

答复: Does Trafodion support to use 'order by' in a subquery

2016-03-24 Thread Liu, Ming (Ming)
Thanks Rohit, That is good to know, after think it again, yes, this is wrong in the first place. I tested in Hive, it doesn’t support that syntax either, but seems some RDBMS (Oracle, DB2) allow this syntax but ignore it. However, It will be more user friendly that optimizer or parser simply