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.*
