[jira] [Created] (DRILL-6220) Drill Connectivity Issue with Kerberorized HDFS
Deepak Shivamurthy created DRILL-6220:
-
Summary: Drill Connectivity Issue with Kerberorized HDFS
Key: DRILL-6220
URL: https://issues.apache.org/jira/browse/DRILL-6220
Project: Apache Drill
Issue Type: Bug
Components: Client - HTTP, Client - JDBC, Documentation
Affects Versions: 1.11.0
Reporter: Deepak Shivamurthy
Hi Team,
We are facing issue when starting drill after adding below config in
drill-override.conf.. any help here would be appreciated. Thanks
impersonation: {
enabled: true,
max_chained_user_hops: 3
},
security: {
user.auth.enabled:true,
auth.mechanisms:["KERBEROS","PLAIN"],
auth.principal:"[x...@bdp.com|mailto:x...@bdp.com]",
auth.keytab:"/etc/security/keytabs/xxx.keytab",
user.encryption.sasl.enabled: true
}
{color:#1e1e1e} {color}
{color:#1e1e1e} {color}
{color:#1e1e1e}[root@NVMBD2AJJ110V04 apache-drill-1.11.0]# bin/sqlline -u
"jdbc:drill:zk=journalnode1.jiolabs.com:2181;auth=kerberos;service_name=drill;service_host=nvmbd2ajj110v04;keytab=/etc/security/keytabs/drill.keytab;principal=drill/[nvmbd2ajj110...@rilbdp.com|mailto:nvmbd2ajj110...@rilbdp.com];
-n "drill/[nvmbd2ajj110...@rilbdp.com|mailto:nvmbd2ajj110...@rilbdp.com]"
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=512M;
support was removed in 8.0
apache drill 1.11.0
"a drill in the hand is better than two in the bush"
0:
jdbc:drill:zk=[journalnode1.jiolabs.com:218|http://journalnode1.jiolabs.com:218/]>
show schemas;
Error: RESOURCE ERROR: Failed to create schema tree.
[Error Id: 87691a44-9ae3-4765-bdba-52ef4f3eaa9c on NVMBD2AJJ110V04:31010]
(state=,code=0)
0:
jdbc:drill:zk=[journalnode1.jiolabs.com:218|http://journalnode1.jiolabs.com:218/]>
{color}
{color:#1e1e1e} {color}
{color:#1e1e1e} {color}
{color:#1e1e1e}
{color}
Regards,
Deepak S
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
[jira] [Comment Edited] (DRILL-4933) Column aliasing isn’t working when we use partition by clause with row_number() [Ranking Window Functions]
[ https://issues.apache.org/jira/browse/DRILL-4933?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15551303#comment-15551303 ] Deepak Shivamurthy edited comment on DRILL-4933 at 10/6/16 8:20 AM: Thanks Khurram Faraaz Could you please send across URL to download stable drill 1.9.0 as I could not see in the below url; http://apache.mirrors.hoobly.com/drill/ was (Author: deepaks): Could you please send across URL to download stable drill 1.9.0 as I could not see in the below url; http://apache.mirrors.hoobly.com/drill/ > Column aliasing isn’t working when we use partition by clause with > row_number() [Ranking Window Functions] > -- > > Key: DRILL-4933 > URL: https://issues.apache.org/jira/browse/DRILL-4933 > Project: Apache Drill > Issue Type: Bug > Components: Functions - Drill >Affects Versions: 1.8.0 >Reporter: Deepak Shivamurthy >Priority: Minor > > I have run below query and alias is done on the third column, but still alias > does not working. > select ID, sts_utc, row_number() over(partition by ID order by sts_utc) as > `rownum` from dfs.`/tmp/events` limit 10; > Output: > ID sts_utc, $2 > I would be expecting column rownum instead of $2.. (even i have other column > names, still aliasing didnt work) -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (DRILL-4933) Column aliasing isn’t working when we use partition by clause with row_number() [Ranking Window Functions]
[ https://issues.apache.org/jira/browse/DRILL-4933?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15551303#comment-15551303 ] Deepak Shivamurthy commented on DRILL-4933: --- Could you please send across URL to download stable drill 1.9.0 as I could not see in the below url; http://apache.mirrors.hoobly.com/drill/ > Column aliasing isn’t working when we use partition by clause with > row_number() [Ranking Window Functions] > -- > > Key: DRILL-4933 > URL: https://issues.apache.org/jira/browse/DRILL-4933 > Project: Apache Drill > Issue Type: Bug > Components: Functions - Drill >Affects Versions: 1.8.0 >Reporter: Deepak Shivamurthy >Priority: Minor > > I have run below query and alias is done on the third column, but still alias > does not working. > select ID, sts_utc, row_number() over(partition by ID order by sts_utc) as > `rownum` from dfs.`/tmp/events` limit 10; > Output: > ID sts_utc, $2 > I would be expecting column rownum instead of $2.. (even i have other column > names, still aliasing didnt work) -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (DRILL-4933) Column aliasing isn’t working when we use partition by clause with row_number() [Ranking Window Functions]
Deepak Shivamurthy created DRILL-4933: - Summary: Column aliasing isn’t working when we use partition by clause with row_number() [Ranking Window Functions] Key: DRILL-4933 URL: https://issues.apache.org/jira/browse/DRILL-4933 Project: Apache Drill Issue Type: Bug Components: Functions - Drill Affects Versions: 1.8.0 Reporter: Deepak Shivamurthy Priority: Minor I have run below query and alias is done on the third column, but still alias does not working. select ID, sts_utc, row_number() over(partition by ID order by sts_utc) as `rownum` from dfs.`/tmp/events` limit 10; Output: ID sts_utc, $2 I would be expecting column rownum instead of $2.. (even i have other column names, still aliasing didnt work) -- This message was sent by Atlassian JIRA (v6.3.4#6332)
