You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Sanjiv Kumar <kt...@gmail.com> on 2016/05/18 06:07:17 UTC
Drill Issues
Hello
I am facing some problem while using drill. I have also posted
earlier my problem one by one, but didn't get any proper solution for that.
This time again i am posting my problem.
1) Join Query Problem (for details check in April 16 with *subject*:-
Regarding
Join Query Problem)
2) Multiple Column having same name & same data type problem (for details
check in April 16 *Subject*:- Multiple Column having same name & same data
type problem)
3) Authentication in Window Operating System (for details check in April 16
*SUBJECT*:- Regarding Drill Authentication)
I hope this time i get some proper solution from Drill.
......................
Thanks & Regards
*Sanjiv Kumar*
Re: Drill Issues
Posted by Khurram Faraaz <kf...@maprtech.com>.
You can use CONVERT_TO and CONVERT_FROM functions, to get HDFS bytes
read/write from drill queries.
https://drill.apache.org/docs/supported-data-types/#data-types-for-convert_to-and-convert_from-functions
On Mon, May 23, 2016 at 11:28 AM, vinita.goyal@siemens.com <
vinita.goyal@siemens.com> wrote:
> Hi
>
> How do I get HDFS bytes read and write information for drill queries?
>
>
>
> Thanks and Regards,
> Vinita Goyal
>
>
>
>
>
RE: Drill Issues
Posted by "vinita.goyal@siemens.com" <vi...@siemens.com>.
Hi
How do I get HDFS bytes read and write information for drill queries?
Thanks and Regards,
Vinita Goyal
Re: Drill Issues
Posted by Tushar Pathare <tp...@sidra.org>.
Hello Vinita,
A simple storage plugins for Hive looks like this.
{
"type": "hive",
"enabled": true,
"configProps": {
"hive.metastore.uris": "thrift://scflexnode09:9083",
"hive.metastore.sasl.enabled": "false",
"fs.default.name": "hdfs://scflexnode09:8020/"
}
}
Hopes this helps
Tushar B Pathare
High Performance Computing (HPC) Administrator
General Parallel File System
Scientific Computing
Bioinformatics Division
Research
Sidra Medical and Research Centre
Sidra OPC Building
PO Box 26999 | Doha, Qatar
Near QNCC,5th Floor
Office 4003 3333 ext 37443 | M +974 74793547
tpathare@sidra.org | www.sidra.org <http://www.sidra.org/>
Follow us on:
<https://www.facebook.com/SidraMedicalAndResearchCenter>
<https://twitter.com/sidra>
<https://www.linkedin.com/company/sidra-medical-and-research-center>
<https://www.instagram.com/sidramedicalandresearchcenter/>
<https://www.youtube.com/user/SidraMedical>
On 5/23/16, 9:00 AM, "vinita.goyal@siemens.com" <vi...@siemens.com> wrote:
>Hi..
>
>How can I use Hive tables for running drill queries. What will be the storage plug-in? Please help I tried it a lot But could not get how to do.
>
>Thanks and Regards
>Vinita Goyal
Disclaimer: This email and its attachments may be confidential and are intended solely for the use of the individual to whom it is addressed. If you are not the intended recipient, any reading, printing, storage, disclosure, copying or any other action taken in respect of this e-mail is prohibited and may be unlawful. If you are not the intended recipient, please notify the sender immediately by using the reply function and then permanently delete what you have received. Any views or opinions expressed are solely those of the author and do not necessarily represent those of Sidra Medical and Research Center.
RE: Drill Issues
Posted by "vinita.goyal@siemens.com" <vi...@siemens.com>.
Hi..
How can I use Hive tables for running drill queries. What will be the storage plug-in? Please help I tried it a lot But could not get how to do.
Thanks and Regards
Vinita Goyal
Fwd: Drill Issues
Posted by Sanjiv Kumar <kt...@gmail.com>.
Hello
I am facing some problem while using drill. I have also posted
earlier my problem one by one, but didn't get any proper solution for that.
This time again i am posting my problem.
1) Join Query Problem (for details check in April 16 with *subject*:-
Regarding
Join Query Problem)
2) Multiple Column having same name & same data type problem (for details
check in April 16 *Subject*:- Multiple Column having same name & same data
type problem)
3) Authentication in Window Operating System (for details check in April 16
*SUBJECT*:- Regarding Drill Authentication)
I hope this time i get some proper solution from Drill.
......................
Thanks & Regards
*Sanjiv Kumar*
--
......................
Thanks & Regards
*Sanjiv Kumar*
Re: Drill Issues
Posted by Chunhui Shi <cs...@maprtech.com>.
Hi Sanjiv,
3) As to authentication in windows, I think you already got a proper
reply, that is you have to implement your own authenticator. Depends on
your windows environment, you can decide either call windows API to check
user+password, or connect Active Directory either through LDAP or Kerberos
to get authenticated, I think there are some example around in mail lists.
2) As to this one, I think you did not provide the requested information --
the plan of the problematic query, you can get the plan by running "explain
plan for <your query>" in sqlline.
1) For 1 and 2, I think you can file a JIRA for each of the issues, and
post plan and attach drillbit.log to the JIRA.
On Tue, May 17, 2016 at 11:41 PM, Khurram Faraaz <kf...@maprtech.com>
wrote:
> Hello Sanjiv,
>
> I work with the Drill team. I don't have your previous email (I joined the
> user group recently). I can take a look at your join query problem and your
> multiple columns having same name and same type issue.
>
> Please share/resend your earlier email, and I can take a look.
> Two things (1) please share the explain plan for your join query problem,
> if you can get one. (2) please share information from drillbit.log related
> to your same name same type many columns issue.
>
> Also I assume your Drillbits are setup on a Linux/UNIX environment.
>
> Thanks,
> Khurram
>
> On Wed, May 18, 2016 at 11:37 AM, Sanjiv Kumar <kt...@gmail.com>
> wrote:
>
> > Hello
> > I am facing some problem while using drill. I have also posted
> > earlier my problem one by one, but didn't get any proper solution for
> that.
> > This time again i am posting my problem.
> >
> > 1) Join Query Problem (for details check in April 16 with *subject*:-
> > Regarding
> > Join Query Problem)
> >
> > 2) Multiple Column having same name & same data type problem (for details
> > check in April 16 *Subject*:- Multiple Column having same name & same
> data
> > type problem)
> >
> > 3) Authentication in Window Operating System (for details check in April
> 16
> > *SUBJECT*:- Regarding Drill Authentication)
> >
> >
> > I hope this time i get some proper solution from Drill.
> >
> >
> >
> > ......................
> > Thanks & Regards
> > *Sanjiv Kumar*
> >
>
Re: Drill Issues
Posted by Khurram Faraaz <kf...@maprtech.com>.
Hello Sanjiv,
I work with the Drill team. I don't have your previous email (I joined the
user group recently). I can take a look at your join query problem and your
multiple columns having same name and same type issue.
Please share/resend your earlier email, and I can take a look.
Two things (1) please share the explain plan for your join query problem,
if you can get one. (2) please share information from drillbit.log related
to your same name same type many columns issue.
Also I assume your Drillbits are setup on a Linux/UNIX environment.
Thanks,
Khurram
On Wed, May 18, 2016 at 11:37 AM, Sanjiv Kumar <kt...@gmail.com> wrote:
> Hello
> I am facing some problem while using drill. I have also posted
> earlier my problem one by one, but didn't get any proper solution for that.
> This time again i am posting my problem.
>
> 1) Join Query Problem (for details check in April 16 with *subject*:-
> Regarding
> Join Query Problem)
>
> 2) Multiple Column having same name & same data type problem (for details
> check in April 16 *Subject*:- Multiple Column having same name & same data
> type problem)
>
> 3) Authentication in Window Operating System (for details check in April 16
> *SUBJECT*:- Regarding Drill Authentication)
>
>
> I hope this time i get some proper solution from Drill.
>
>
>
> ......................
> Thanks & Regards
> *Sanjiv Kumar*
>