Skip to content

Instantly share code, notes, and snippets.

View ramannanda9's full-sized avatar

Ramandeep Singh ramannanda9

View GitHub Profile
@ramannanda9
ramannanda9 / filter.scala
Last active July 31, 2017 19:51
filter in scala
def filter[K](arr: List[K], f: K => Boolean): List[K] = arr match {
case Nil => arr
case list: List[K] => if (f(list.head)) list.head :: filter(list.tail, f) else filter(list.tail, f)
}
val listToFilter = 2 :: 5 :: Nil
listToFilter.filter(_ > 2)
@ramannanda9
ramannanda9 / OID Operations
Created September 8, 2011 21:30
ADF Security Utility class
import java.security.Principal;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.HashSet;
import java.util.Hashtable;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.ResourceBundle;
import java.util.Set;
@ramannanda9
ramannanda9 / NWayMerge.scala
Last active June 18, 2017 02:26
Some Scala Transpose Experiments.
import scala.annotation.tailrec
import scala.collection.mutable.ListBuffer
case class Priceable(id: String,measure:String,value: Double)
val results=Seq(
Priceable("$APPL","PV",311.0),
Priceable("$APPL","Growth",3.0),
Priceable("$IBM","PV",100),
Priceable("$IBM","Growth",0.5),
@ramannanda9
ramannanda9 / max_salary.sql
Created October 5, 2016 01:04
Max Salary by Department
select e.ename, e.sal, d.dname from emp e,dept d where e.sal in (select max(e.sal) from emp e group by deptno) and e.deptno=d.deptno
@ramannanda9
ramannanda9 / analytic.sql
Created July 20, 2016 01:17
analytic function
select empno, deptno, row_number() over (partition by deptno order by 1) sequence_num from scott.emp;
@ramannanda9
ramannanda9 / word_count.pig
Created March 1, 2016 21:10
PIG script for searching words
input_records = LOAD 'hdfs://quickstart.cloudera:8020/user/cloudera/pig_word_count/input.txt' as(tweet_text:chararray);
filter_words = LOAD 'hdfs://quickstart.cloudera:8020/user/cloudera/pig_word_count/filter_words.txt' as (filter_word:chararray);
input_records = FOREACH input_records GENERATE REPLACE(tweet_text,'([^a-zA-Z\\s]+)',' ') as tweet_text;
tokenize_words = FOREACH input_records GENERATE flatten(TOKENIZE(LOWER(tweet_text))) as word;
--INEFFICIENT BUT NECCESSARY to print filtered_word
cleanedData = JOIN filter_words by LOWER((filter_word)) FULL, tokenize_words by LOWER(word);
--REMOVE NON MATCHIN WORDS EXCEPT THE ONE IN WHICH THE FILTER WORD IS NOT NULL
filtered_data = FILTER cleanedData by ((word IS NULL and filter_word IS NOT NULL ) or word matches LOWER(filter_word) ) ;
grouped_words = GROUP filtered_data by filter_word;
--GROUP THEM BY group key and only count when the word is not empty, Since null is not counted so it works
@ramannanda9
ramannanda9 / gist:8149182
Created December 27, 2013 16:18
Enabling filtering adf table
//in bindings add
<searchRegion Criteria=""
Customizer="oracle.jbo.uicli.binding.JUSearchBindingCustomizer"
Binds="IteratorName" id="DummyName"/>
//in fragment use af:table add the following
filterModel="#{bindings.DummyName.queryDescriptor}"
queryListener="#{bindings.DummyName.processQuery}"
@ramannanda9
ramannanda9 / gist:8147672
Last active January 1, 2016 12:58
Recursive delete organization, Its users or permissions, remove inheritance and itself.
/**
* This method recursively deletes and organization and its permission objects/users
* Its descendants if any are there before deleting the organization
* @param orgUnit The orgUnit name
* @param delAdmMgr A delegated Admin Manager instance
* @param revMgr A Delegated review manager instance
* @param rvMgr A review manager instance
* @param admMgr A admin manager instance
* @return
*/
@ramannanda9
ramannanda9 / gist:7344308
Created November 6, 2013 21:21
AMimpl test and OIDOperations class
package model;
import java.util.Map;
import java.util.logging.Level;
import model.common.AppModule;
import oracle.adf.share.logging.ADFLogger;
@ramannanda9
ramannanda9 / 0_reuse_code.js
Created September 28, 2013 14:24
Here are some things you can do with Gists in GistBox.
// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console