How to install & Configure Apache Thrift in Ubuntu 16.04

The Apache Thrift software framework, for scalable cross-language services development, combines a software stack with a code generation engine to build services that work efficiently and seamlessly between C++, Java, Python, PHP, Ruby, Erlang, Perl, Haskell, C#, Cocoa, JavaScript, Node.js, Smalltalk, OCaml and Delphi and other languages. Installation Step by Step Guide: To use with […]

Read More

Apache Sqoop Important Commands

1. Checking the version of your Sqoop sqoop version 2. Getting the help from Sqoop about its Sub-Utilities sqoop help 3. Simple import of data sqoop import –connect jdbc:mysql://localhost/dbName –table tableName –username root -P -m 1 4. Specifying the target dir. as /user/tardir sqoop import –connect jdbc:mysql://localhost/dbName –table tableName –username root –target-dir /user/tardir -P -m […]

Read More

Apache Drill Installation, Storage Plugins Configuration for HBASE, HIVE, CP and DFS for beginners.

Introduction Drill is a very useful query engine it provide the facility to use it for multi-purpose. Apache drill definition is “Apache Drill is a low latency distributed query engine for large-scale datasets, including structured and semi-structured/nested data. Drill is designed to scale to several thousands of nodes and query petabytes of data at interactive […]

Read More

How to Connect to Drill via JDBC fails with IllegalStateException (java.lang.IllegalStateException: No DrillbitEndpoint can be found)

This  is my own  Generated code which I am using to connect to Drill via JDBC and query  *.csv file on my cloudera sandbox. Code: try{ Class.forName(“org.apache.drill.jdbc.Driver”); Connection connection =DriverManager.getConnection(“jdbc:drill:zk=localhost:2181″,”root”,”cloudera”); Statement st = connection.createStatement(); ResultSet rs = st.executeQuery(“SELECT * from dfs.`/home/cloudera/Desktop/test.csv`”); while(rs.next()){ System.out.println(rs.getString(1)); ….. } }catch(Exception e){ //Handle errors e.printStackTrace(); }

Read More