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(); […]

Formatting JSON with VIM

I am working on an analytics project where we generate very complicated medical analysis and put it in a hierarchical data model. { “test” : { “test1” : “val1” } } Open the JSON in vim and use python -m json.tool :%!python -m json.tool Results { “test”: { “test1”: “val1” } } References https://coderwall.com/p/faceag/format-json-in-vim https://til.hashrocket.com/posts/ha0ci0pvkj-format-json-in-vim-with-jq […]

Urban Code Deploy: When a value doesn’t exist?

Urban Code Deploy: When a value doesn’t exist? Recently, I ran into an issue with a resource referece in an Urban Code Deploy (UCD) resource that did not yet exist. When the value, that doesn’t yet exist I found this a great tip (UCD Documentation). Change from ${p:resource/value-not-yet-populated} to ${p?:resource/value-not-yet-populated} UCD replaces the missing value […]

Generating Swagger as part of a Maven Build

Most of my projects use Maven to build and coordinate dependencies and run unit and build integration tests. I’ve found it a real pain that I could not generate my swagger docs as part of the build. I have found a really easy way. In Jenkins, I have a downstream job that runs specific maven […]

JAX-RS Servlet properties

Recently, I have done a good amount of JAX-RS development, and I needed to kept hitting an issue with forms parameter validation errors on my query params.  The errors kept driving me nuts, until I read the documentation and found – jersey.config.servlet.form.queryParams.disabled .   I also learned the java property is available for those with code […]