1) As I said, you can use various SQL clients to query Drill through jdbc/odbc. That's quite practical and we've a similar setup for our end-users here. Some SQL clients should be able to create basic charts etc. using your queries.
2) So what's the output when you try to see the files from dfs plugin via Drill prompt: select files from dfs.`/user`; If you receive an error, can you please share it here? On 22 October 2015 at 13:45, ganesh <[email protected]> wrote: > Hi, > > Here is the storage plugin. Copied from default DFS storage plugin. > I can query data from apache drill prompt. > > But to make a presentation, I would like to query from soem applications to > have visualisation .. may be table / charts > > > ================================================================= > > { > "type": "file", > "enabled": true, > "connection": "hdfs://localhost:54310/", > "workspaces": { > "root": { > "location": "/user", > "writable": false, > "defaultInputFormat": null > }, > "tmp": { > "location": "/tmp", > "writable": true, > "defaultInputFormat": null > } > }, > "formats": { > "psv": { > "type": "text", > "extensions": [ > "tbl" > ], > "delimiter": "|" > }, > "csv": { > > > ================================================================= > > On Thu, Oct 22, 2015 at 5:01 PM, Mustafa Engin Sözer < > [email protected]> wrote: > > > 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 > > > > > > -- > *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
