#DateForumTypeThreadPost
1723 Aug 2015 @ 10:27 PDTHadoopReplyNeed to get common users for every combination of user IDsThanks Dieter for the solution
1623 Aug 2015 @ 08:34 PDTHadoopTopicNeed to get common users for every combination of user IDsHi, I have a table which has one user ID mapped to multiple other user IDs. I want to get the common user IDs mapped to every two user IDs   My Data looks in the following way User ID Us...
1506 Apr 2015 @ 04:58 PDTGeneralReplyIs there a way to avoid NOT IN function Thanks. Will try out on a few sample datasets and let you know if I have queries.
1402 Apr 2015 @ 05:29 PDTGeneralReplyIs there a way to avoid NOT IN function Thanks ! Will try it out. However, there is a common notion that not exists and not in cannot be used on large datasets and in those circumstances an Exception join is a better idea. Am I right ?
1331 Mar 2015 @ 05:31 PDTGeneralReplyIs there a way to avoid NOT IN function dnoeth - With regard to your above solution, is there anyway I can use the Explain statement to know if 'not exists' is indeed a better idea ?
1224 Mar 2014 @ 02:05 PDTDatabaseReplyJoin Issues - Need help in most efficient way to solve the problemThanks all. We managed to do this through a different medium
1109 Mar 2014 @ 09:37 PDTDatabaseReplyJoin Issues - Need help in most efficient way to solve the problemDieter - Sorry again but any new ideas ?
1005 Mar 2014 @ 07:52 PSTDatabaseReplymy confusion about LEFT JOIN From a pure coding perspective, I think this is the best rule to follow.  When we do table A Left Join Table B -  All conditions on table A should be in 'Where' Clause - This is...
905 Mar 2014 @ 07:47 PSTDatabaseReplyJoin Issues - Need help in most efficient way to solve the problemAgreed totally with you Dieter. But in the actual data we have we feel that the case you have explained would be pretty rare and we are okay with ignorning that though I understand we are compromis...
805 Mar 2014 @ 06:06 PSTDatabaseReplyJoin Issues - Need help in most efficient way to solve the problemDieter - Thanks a lot. If I give a rule saying that always choose a shop which has maximum items, can I write a normal SQL code to achieve that ?  In other words, among all 1000 shops I will...
704 Mar 2014 @ 06:06 PSTDatabaseReplyJoin Issues - Need help in most efficient way to solve the problemDieter - Any suggestions ?
602 Mar 2014 @ 06:05 PSTDatabaseReplyJoin Issues - Need help in most efficient way to solve the problemAny suggestions ?
527 Feb 2014 @ 08:56 PSTDatabaseTopicJoin Issues - Need help in most efficient way to solve the problemHi, I need some help to solve the following problem in the most efficient way.  Consider Table1 -  ShopNbr Item 1 100 1 101 1 102 2 101 2 104 3 100 3 102 3 103 3 104 3 105 ...
427 Feb 2014 @ 08:07 PSTDatabaseReplyQuery regarding Column and row mergeThanks ! That does solve my problem
327 Feb 2014 @ 07:15 PSTDatabaseReplyQuery regarding Column and row mergeThanks Dieter for the quick response :) Just one more clarification(confirming it) - Shouldn't the select statement have the cname as well from T1 ? 
227 Feb 2014 @ 01:56 PSTDatabaseTopicQuery regarding Column and row merge
127 Feb 2014 @ 01:56 PSTDatabaseReplyQuery regarding Column and row mergeHi, I need assistance to create the below table using Tables 1 and 2. Assume Table1 contains - Customernbr, Customername,  Attribute1, Attirbute2 and Attribute3. Consider the attributes to h...