Hello, I am new to un-structured world and just started 1 week back on APACHE DRILL after suggestion from my collegues. We have a semi structured data where we have constraint that we do not know number of columns
I heard that APACHE DRILL is column free applicationa nd with support of JSON format, it allows to create columns on-fly, I converted my data from CSV-like-format to JSON and trying to figure out if it will work for me. Here I hit two issues :- 1) My column were like : 3100.2.1.2 and values like '-2303" or '01/01/2015 02:02:00" Challenge was that column cant be started with Numeric value. So I had to change key as: "t3100.2.1.2" After that things were quite OK, Now I need some help from you guys. To proceed I have to present my work to management as an example. But querying on apache drill console, doesnt seem to be an attractive way to present things. I tried drill explorer too.But didnt find that so good. One thing to note, I am playing with files on Hadoop standalone mode in UBUNTU. To make it appear more good looking, I started with QLIK SENSE .. but was unable to connect it with hadoop file system. It only showed me HIVE FILES. Then I downloaded TABLEAU Trial version ... but I am unable to get Hadoop data here too... Please help me how to proceed. I have presentation on coming Monday. Queries are quite ready .. I just need to show in visualization form ........ using OPEN SOURCE applications only. Guys please help me. -- *Name: Ganesh Semalty* *Location: Gurgaon,Haryana(India)* *Email Id: [email protected] <[email protected]>* P *Please consider the environment before printing this e-mail - SAVE TREE.*
