Pretty wild stuff. This was in 11.2.0.3.9, EE… SQL> select * from dcspp_order_rel where order_id = ‘EXP1439962334’ and sequence_num = 5; ORDER_ID RELATIONSHIPS SEQUENCE_NUM —————————————- —————————————- ———— EXP1439962334 r406622317 5 SQL> select * from dcspp_order_rel where order_id = ‘EXP1439962334’ and…
Author: Steve
Configure Linux to authenticate with Active Directory
Install samba and krb from yum, then run the following… authconfig –disablecache \ –enablewinbind \ –enablewinbindauth \ –smbsecurity=ads \ –smbworkgroup=howard.local \ –smbrealm=HOWARD.LOCAL \ –enablewinbindusedefaultdomain \ –winbindtemplatehomedir=/home/%U \ –winbindtemplateshell=/bin/bash \ –enablekrb5 \ –krb5realm=HOWARD.LOCAL \ –enablekrb5kdcdns \ –enablekrb5realmdns \ –enablelocauthorize \ –enablemkhomedir…
Weblogic deployment options
stage is the worst term for this. Seriously. stage, to me at least, implies a temporary location. I come from a database background, so a staging table is thought of as the location where data is stored prior to being…
Are files in HDFS immutable?
Call me cynical, I just am a bit of a doubting Thomas. Using our previous write test code, we simply run the exact same test, only we do it twice. [root@cmhlpdlkedat15 ~]# hadoop HDFSWriteTest foobar.txt hdfs://cmhlpdlkedat14.expressco.com:8020 [root@cmhlpdlkedat15 ~]# hdfs dfs…
Getting additional data on a slow hive reducer
We have a query that has been running for almost two hours on the last of 1,009 reducers in the first reduce phase. We wanted to gain additional insight into what it was doing, so we first find the node…
Dump heap programatically
This is one way you can dump the heap of a running JVM from within a page. This is not something you would place in a running production system, as you don’t want random GET’s to keep dumping the heap…
Drop all tables in a schema
This assumes the tables have no integrity constraints related to a table in another schema. This just loops until all tables are dropped. If you are the nervous type, add an exception handler for the integrity constraint exception, and exit…
Hive transactions
Below is just a simple example of hive transactions. These are very useful on slowly changing type 1 dimension tables for which you do not wish to retain history, but only the most recent value of the row. The table…
JDBC batch re-processing
I have always wanted to duplicate how GoldenGate handles batch failures. In GoldenGate, you can set the parameter “batchsql BATCHTRANSOPS 2000”, for example, to send 2000 statements at a time to the database for execution. In general, this is far…
zookeeper and reverse lookups
Suffice it to say, on zookeeper 3.4.6 (at least) you will have all kinds of grief in a kerberos secured cluster if the zookeeper nodes can’t be looked up by passing the IP to get the hostname. Specifically, in the…