Databases Groovlets By Somen Sarkar What is Groovlet? A Groovlet is a Servlet in Groovy script or in other word Servlets in Groovy What it does? The groovlet jar helps us to automatically compile .groovy source files into bytecode. It load the Class and cache...
Business Intelligence Neo4j : Graph Database By Sayali Mahale Neo4j : Graph Database Introduction NoSQL graph database Usecases : include matchmaking, network management, software analytics, scientific research, routing, organizational and project management, recommendations, social networks, and more. Neo4j implements the Property Graph Model efficiently down to the storage level....
Apache Spark MongoDB Connector for Apache Spark By Sayali Mahale MongoDB Connector for Apache Spark Spark supports connector for MongoDB , through which we can execute SQL queries on MongoDB as well as we can perform spark RDD tranformations on MongoDB data. With the connector, you have access to all...
Business Intelligence Change Hive Metastore From Derby to MySQL By Nikhilesh Change Hive metastore from derby to MySQL Make data easy with Helical Insight. Helical Insight is the world's best open source business intelligence tool. Get your 30 Days Trail Version Machine : UBUNTU-14.04 | Hive : HIve 1.2.1...
Databases Foreign Data Wrappers in PostgreSQL By Nikhilesh Foreign Data Wrappers in PostgreSQL Foreign Data Wrapper (FDW) is new concept which introduced in PostgreSQL 9.1. It allows us to access external non-Postgres data in the form of regular Postgres table. FDW allow us to make external data sources (text...
Business Intelligence LATERAL JOIN By Nikhilesh LATERAL JOIN Lateral join is a very incredible feature in Postgres (Postgres 9.3+) . The LATERAL key word can precede a sub-SELECT FROM item. It allows the sub-SELECT to point to the columns of FROM items that appear before it in the FROM list. We can say...
Databases Groovy JsonSlurper By Somen Sarkar JSON Slurper in Groovy What is JSON slurper? JSON slurper is a class in groovy that can be used to parse text or read content into a data structure of lists and maps. In other words we can say that...
Databases JNDI By Somen Sarkar Java Naming and Directory Interface (JNDI) Using JNDI, applications running in distributed environment, helps to look up services independently. How JNDI is useful? During deployment sequence, the same JNDI name can be used in different servers. It helps to provide...
Databases Loading CSV File BatchWise in Talend By Nikhilesh Loading CSV File BatchWise -Talend In a ETL-Job when the source is a flat file for example a CSV File and size of the file is large. To load large files your job has to read the whole file...
Databases Communication Between JSP and SQL By Nikhilesh For the communication between JSP and SQL to take place java plays an important role. You can write the java code in JSP itself. It makes the code more less complicated. You don't need to pass parameters from one file...
Databases Get Month to Date Data using SQL By Nikhilesh Generate Month to Date Report using SQL In this blog we will learn on how to put together a SQL statement that returns the MTD value. Month-to-date (MTD) is a period, starting from the beginning of the current month and...
Databases Generate Year to Date Data in SQL By Nikhilesh Generate Year to Date Data in SQL In this blog we will learn on how to put together a SQL statement that returns the YTD value. Year-to-date (YTD) is a period, starting from the beginning of the current year (either...