Hi, If you only need to show the data but not some sort of report (e.g. as in Microstrategy, Tableau), then you can basically use most SQL clients, for instance SQuirrel, Heidi SQL etc. via jdbc or odbc connection . The following links should help you manage that:
https://drill.apache.org/docs/odbc-jdbc-interfaces/ https://drill.apache.org/docs/using-the-jdbc-driver/ For the Hadoop data problem, can you share your storage plugin settings? Normally you shouldn't have any problems with seeing or querying hdfs data. On 22 October 2015 at 13:18, ganesh <[email protected]> wrote: > 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.* > -- *M. Engin Sözer* Junior Datawarehouse Manager [email protected] Goodgame Studios Theodorstr. 42-90, House 9 22761 Hamburg, Germany Phone: +49 (0)40 219 880 -0 *www.goodgamestudios.com <http://www.goodgamestudios.com>* Goodgame Studios is a brand of Altigi GmbH Altigi GmbH, District court Hamburg, HRB 99869 Board of directors: Dr. Kai Wawrzinek, Dr. Christian Wawrzinek, Fabian Ritter
