http://www.datastax.com/support-forums/topic/loading-data-from-one-table-to-another Software, Support, and Training for Apache Cassandra en-US Wed, 22 May 2013 23:39:30 +0000 http://bbpress.org/?v=1.0.3 q http://www.datastax.com/support-forums/search.php http://www.datastax.com/support-forums/topic/loading-data-from-one-table-to-another#post-2876 Tue, 10 Jul 2012 16:21:03 +0000 awenclaw 2876@http://www.datastax.com/support-forums/ <p>I eliminate possibility that select distinct is causing problems.<br /> When I execute :<br /> insert overwrite ....<br /> select ....<br /> UNION ALL<br /> select...<br /> and after that count number of rows inserted to table I get 1987 rows.</p> <p>When I execute:<br /> select count(*) from (<br /> select ...<br /> UNION ALL<br /> select... )<br /> I get 2000 rows. So there is something wrong with using UNION ALL with insert overwrite (or there is something wrong with me...)</p> <p>Did anybody had similar problems or know the solution? </p> http://www.datastax.com/support-forums/topic/loading-data-from-one-table-to-another#post-2828 Mon, 09 Jul 2012 17:53:52 +0000 awenclaw 2828@http://www.datastax.com/support-forums/ <p>Hi!<br /> I have simple problem but I have no idea what's happening. I'm trying to load table s_kontrachenci from table przelewy_zrodlo using hive. I'm useing such query:</p> <p>insert owerwrite table s_kontrachenci<br /> select distinct kontrachenci.klucz, kontrachenci.nazwa, kontrachenci.typ from (<br /> select<br /> concat('key_', nazwa_zleceniodawcy) AS klucz,<br /> nazwa_zleceniodawcy AS nazwa,<br /> case when substr(nr_rach_zleceniodawcy, 1, 1) &lt; 5 then 'WEW' else 'ZEW' AS typ<br /> from przelewy_zrodlo<br /> UNION ALL<br /> select<br /> concat('key_', nazwa_zleceniodawcy) AS klucz,<br /> nazwa_zleceniodawcy AS nazwa,<br /> case when substr(nr_rach_zleceniodawcy, 1, 1) &lt; 5 then 'WEW' else 'ZEW' AS typ<br /> from przelewy_zrodlo<br /> ) kontrachenci;</p> <p>After I load data to table s_kontrachenci I execute query:</p> <p>select count(*) from s_kontrachenci;</p> <p>and I get result 1987 rows.</p> <p>But when I execute such query:</p> <p>select count(*) from (<br /> select distinct kontrachenci.klucz, kontrachenci.nazwa, kontrachenci.typ from (<br /> select<br /> concat('key_', nazwa_zleceniodawcy) AS klucz,<br /> nazwa_zleceniodawcy AS nazwa,<br /> case when substr(nr_rach_zleceniodawcy, 1, 1) &lt; 5 then 'WEW' else 'ZEW' AS typ<br /> from przelewy_zrodlo<br /> UNION ALL<br /> select<br /> concat('key_', nazwa_zleceniodawcy) AS klucz,<br /> nazwa_zleceniodawcy AS nazwa,<br /> case when substr(nr_rach_zleceniodawcy, 1, 1) &lt; 5 then 'WEW' else 'ZEW' AS typ<br /> from przelewy_zrodlo<br /> ) kontrachenci<br /> ) kontr;</p> <p>I get 1991 rows. And now I'm very confused because in my opinion both queries should return same number of rows. Any ideas why number of rows are diffrent for those queries?</p> <p>I should add information that i use such structure:<br /> select distinct ... from (<br /> select ... from ...<br /> UNION ALL<br /> select ... from) ...;<br /> Because there is no UNION in hive and in my opinion this should work as UNION.</p> <p>Any help would be appreciate!<br /> Thanks in advance! </p>