[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&focusedCommentId=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&focusedCommentId=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)