Re: Quick Steps to export and import Drill views

2015-01-28 Thread Jacques Nadeau
Can you create a short markdown page for this and we do a pull request to the gh-pages branch so we can add to the markdown docs? Also would be good to note here that all views are actually maintained independent of Drill. So you can always just copy and move around views as they are simply JSON

Re: Quick Steps to export and import Drill views

2015-01-28 Thread Andries Engelbrecht
Is there a function in Drill to recognize the .drill JSON files as views? I.e. copy .drill files from one cluster to another and pick it up vs recreating. I have had issues with previous version upgrades and views, the current upgrade instructions will pretty much also loose the views in the

Using Drill with JDBC hangs

2015-01-28 Thread Denys Pavlov
Hi all, I am trying to use Drill programmatically in Java through the JDBC driver. However, when I try to execute the query, the application hangs and never returns the ResultSet. When I execute the exact same query in sqlline, everything executes fine. The code snippet is below and should work

Re: Using Drill with JDBC hangs

2015-01-28 Thread Carol McDonald
I think jdbc requires zookeeper (?). The following works with drill on the mapr sandbox: public static void main(String[] args) throws Exception { String driver = org.apache.drill.jdbc.Driver; String url = jdbc:drill:zk=maprdemo:5181/drill/demo_mapr_com-drillbits;

HBase storage plugin updated to support HBase 0.98

2015-01-28 Thread Aditya
Folks, With the commit of DRILL-2090[1] patch, I have updated the HBase storage plugin to support HBase 0.98. As a result, from now[2] onward Drill will not work with HBase 0.94. Regards, aditya... [1] https://issues.apache.org/jira/browse/DRILL-2090 [2] Release 0.8.0 -- Forwarded

Re: Quick Steps to export and import Drill views

2015-01-28 Thread Sudhakar Thota
Andries, Please remember to add one more thing. 1. Save storage plugins 2. And validating the output file for shortened SQLs if things go beyond 1 lines. Some thing in similar lines as mentioned below. If the numbers don’t match increase the width,

Re: Quick Steps to export and import Drill views

2015-01-28 Thread Andries Engelbrecht
Thanks Sudhakar ( and David Kewley). Here is a quick update to add the validation steps and the typo in the original. Let’s see if there are any other issues with these steps or a simpler implementation. 0. Verify that the storage plugin and dfs workspaces are the same for the current and new

FYI: NoSchema Revolution event with Hive Big Data Think Tank Meetup Group tonight

2015-01-28 Thread Daniel Barclay
For whomever is interested, the Hive Big Data Think Tank Meetup Group is having a NoSchema Revolution event tonight. See http://www.meetup.com/SF-Bay-Areas-Big-Data-Think-Tank/events/219395393/ Daniel -- Daniel Barclay MapR Technologies