dev
a.id value to b.id value  one to one
remark   Multiple Input Rows
 scala> cc.sql("select count(a.remark),count(distinct a.remark),count(a.id),count(distinct a.id),count(b.id),count(distinct b.id)  from c_indextest1 a,c_indextest2 b  where a.id=b.id").show;
+-------------+----------------------+---------+------------------+---------+------------------+
|count(remark)|  count(DISTINCT remark)|  count(a.id)  |count(DISTINCT a.id)|count(b.id)          |   count(DISTINCT b.id)|
+-------------+----------------------+---------+------------------+---------+------------------+
|       340000|                     1                         |      340000  |         340000          |       340000        |  340000                    |
+-------------+----------------------+---------+------------------+---------+------------------+

scala> cc.sql("select count(b.id),count(distinct b.id),count(b.remark),count(distinct b.remark) from c_indextest2 b").show;
+---------+------------------+-------------+----------------------+            
|count(id)|count(DISTINCT id)|count(remark)|count(DISTINCT remark)|
+---------+------------------+-------------+----------------------+
| 17000000|          17000000|     17000000|                     1|
+---------+------------------+-------------+----------------------+
scala> cc.sql("select count(b.id),count(distinct b.id),count(b.remark),count(distinct b.remark) from c_indextest1 b").show;
+---------+------------------+-------------+----------------------+            
|count(id)|count(DISTINCT id)|count(remark)|count(DISTINCT remark)|
+---------+------------------+-------------+----------------------+
|   340000|            340000|       340000|                     1|
+---------+------------------+-------------+----------------------+

a.id value to b.id value  one to one
a.remark update b.remark  

cc.sql("update c_indextest2 b set (b.remark)=(select a.remark from  c_indextest1 a where a.id=b.id)").show;
a.id value to b.id value  one to one

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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB