I can think of two possibilities: 1) Check your ODBC connection string, advanced properties. Make sure dfs is not excluded.
2) I've not used Qlik Sense but one suggestion is: try create a view out of your files using drill prompt. That will create a table entry in the INFORMATION_SCHEMA. Check if you'll see your view that way. CREATE VIEW myview AS SELECT .... FROM myfile; On 22 October 2015 at 14:13, ganesh <[email protected]> wrote: > Hi, > > 1) I tried Tableau and qlicksense for chart / tables. But cant see files > from hdfs. > > will share the snapshot soon > > 2) from apache prompt, I can access hdfs files and can also query them. > > > > On Thu, Oct 22, 2015 at 5:37 PM, Mustafa Engin Sözer < > [email protected]> wrote: > > > 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 > > > > > > -- > *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
