Jupyter Notebook: Email Analysis to a Lotus Notes View

I wanted to do an analysis of my emails since I joined IBM, and see the flow of messages in-and-out of my inbox. With my preferences for Jupyter Notebooks, I built a small notebook for analysis. StepsOpen IBM Lotus Notes Rich Client Open the Notes Database with the View you want to analyze. Select the […]

VIM – JOIN Conditions with Unicode and ASCII

JOIN Conditions with Unicode and ASCII I cannot stress the dangers of copying data from Excel or HTML and assuming that it’s ASCII. For example U+0040 is the unicode version of @. We ingested the unicode version and couldn’t see why a JOIN condition on the data table wasn’t working. I looked at the source […]

Remove Duplicates in DB2 Columnar Format

I had dupe data in my OLAP table, where the columnar data can be duplicated based on event id. (I loaded data 2x). I had to differentiate the data and remove the duplicates, so I assigned row_numbers over a partition ordered by. I hope this helps you. db2 “update (select OME.*, row_number() over(partition by IDN_EVENT_ID […]

Maven Animal Sniffer Plugin

For the past few years, most of my personal and professional projects are built using Maven.  The dependency management and corresponding build lifecycle enable me to do some complex builds (for instance HBase 1.2.5 Client Jars). Command mvn dependency:tree -f demo-app/pom.xml Result [INFO] demo.app:demo-app:jar:1.0-SNAPSHOT [INFO] +- junit:junit:jar:4.12:test [INFO] | \- org.hamcrest:hamcrest-core:jar:1.3:test [INFO] \- org.apache.hbase:hbase:pom:1.2.5:compile [INFO] […]

Using jjs to confirm issue with DatatypeConverter in WebSphere Liberty

I kept running into a funky ‘java.lang.NullPointerException’ with the WebSphere Liberty included DataValidator. To debug the issue, I used the jjs – nashorn engine If you need, to figure out where the class is located try { Class c = Class.forName(“javax.xml.bind.DatatypeConverter”); System.out.println(“Location ” + c.getProtectionDomain().getCodeSource().getLocation()); } catch (ClassNotFoundException e1) { TODO Auto-generated catch block e1.printStackTrace(); […]