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

Welcome Miri Infotech Blog

Welcome to Miri Infotech Blog. We are an ISO certified software consulting firm, with enduring proficiency in providing Software Development, Web Application Development, Website Design, Embedded System Development and Customized Software Application Development stands proud to say that Quality is our essence. Miri Infotech was founded in the year 2003, and its corporate head office […]

Read More