dev
 
scala> cc.sql(" select  c.tupleId,count(*)  from (select a.remark,a.id, getTupleId() as tupleId from c_indextest1 a,c_indextest2 b where a.id=b.id) c group by c.tupleId having count(*)>1").show;
+-------+--------+                                                              
|tupleId|count(1)|
+-------+--------+
+-------+--------+

no Multiple input rows
yixu2001
 
From: sounak
Date: 2017-10-20 10:57
To: dev
Subject: Re: Re: Update statement failed with "Multiple input rows matched for same row" in version 1.2.0,
Slight rectification in typo of the query syntax
 
" select a.remark,a.id, getTupleId() as *tupleId* from c_indextest1 a,
c_indextest2
b where a.id=b.id;"
 
On Fri, Oct 20, 2017 at 7:54 AM, sounak <[EMAIL PROTECTED]> wrote:
 
 
 
 
Thanks
Sounak