Hi,
Am developing a UDF called SESSION_ID as detailed in issue:
https://issues.apache.org/jira/browse/DRILL-5043
It does not take any input parameters. Now, I can only invoke it using
parenthesis as in:
SELECT SESSION_ID() FROM (Values(1));
I would like to know what do I need to do if
I don’t know about Drill, but in Calcite you declare the function (SqlOperator)
such that the getSyntax() method returns SqlSyntax.FUNCTION_ID.
SqlCurrentDateFunction (CURRENT_DATE) is an example of this.
> On Dec 19, 2016, at 12:00 AM, Nagarajan Chinnasamy
> wrote:
>
> Hi,
>
> Am developing
Hi,
Am developing a UDF called SESSION_ID as detailed in issue:
https://issues.apache.org/jira/browse/DRILL-5043
It does not take any input parameters. Now, I can only invoke it using
parenthesis as in:
SELECT SESSION_ID() FROM (Values(1));
I would like to know what do I need to do if
Github user vdiravka commented on a diff in the pull request:
https://github.com/apache/drill/pull/687#discussion_r93028597
--- Diff:
exec/java-exec/src/test/java/org/apache/drill/exec/physical/impl/writer/TestCorruptParquetDateCorrection.java
---
@@ -201,68 +203,34 @@ public void
Github user vdiravka commented on a diff in the pull request:
https://github.com/apache/drill/pull/687#discussion_r93028681
--- Diff:
exec/java-exec/src/test/java/org/apache/drill/exec/physical/impl/writer/TestCorruptParquetDateCorrection.java
---
@@ -273,26 +241,28 @@ public void
Github user arina-ielchiieva commented on a diff in the pull request:
https://github.com/apache/drill/pull/666#discussion_r91706453
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/planner/sql/handlers/DropTableHandler.java
---
@@ -55,35 +57,48 @@ public DropTableHandl
Github user arina-ielchiieva commented on a diff in the pull request:
https://github.com/apache/drill/pull/666#discussion_r91706926
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/planner/sql/handlers/DropTableHandler.java
---
@@ -55,35 +57,48 @@ public DropTableHandl
Github user arina-ielchiieva commented on a diff in the pull request:
https://github.com/apache/drill/pull/666#discussion_r91708725
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/rpc/user/UserSession.java ---
@@ -207,25 +239,165 @@ public SchemaPlus getDefaultSchema(S
Github user arina-ielchiieva commented on a diff in the pull request:
https://github.com/apache/drill/pull/666#discussion_r91708832
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/rpc/user/UserSession.java ---
@@ -207,25 +239,165 @@ public SchemaPlus getDefaultSchema(S
Github user arina-ielchiieva commented on a diff in the pull request:
https://github.com/apache/drill/pull/666#discussion_r91709435
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/store/SchemaConfig.java ---
@@ -94,12 +94,16 @@ public ViewExpansionContext getViewExpans
Github user arina-ielchiieva commented on a diff in the pull request:
https://github.com/apache/drill/pull/666#discussion_r91708701
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/rpc/user/UserSession.java ---
@@ -115,6 +145,8 @@ public UserSession build() {
Github user arina-ielchiieva commented on a diff in the pull request:
https://github.com/apache/drill/pull/666#discussion_r91707161
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/planner/sql/handlers/ViewHandler.java
---
@@ -74,36 +74,51 @@ public PhysicalPlan getPla
Github user arina-ielchiieva commented on a diff in the pull request:
https://github.com/apache/drill/pull/666#discussion_r91709387
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/store/SchemaConfig.java ---
@@ -94,12 +94,16 @@ public ViewExpansionContext getViewExpans
Github user arina-ielchiieva commented on a diff in the pull request:
https://github.com/apache/drill/pull/666#discussion_r91707928
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/rpc/user/UserSession.java ---
@@ -55,13 +61,37 @@
private OptionManager sessionOpt
Github user arina-ielchiieva commented on a diff in the pull request:
https://github.com/apache/drill/pull/666#discussion_r91707181
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/rpc/user/UserSession.java ---
@@ -30,15 +33,18 @@
import org.apache.calcite.schema.S
Github user arina-ielchiieva commented on a diff in the pull request:
https://github.com/apache/drill/pull/666#discussion_r91706305
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/planner/logical/FileSystemCreateTableEntry.java
---
@@ -47,28 +47,33 @@
private F
Github user arina-ielchiieva commented on a diff in the pull request:
https://github.com/apache/drill/pull/666#discussion_r93030294
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/store/parquet/ParquetRecordWriter.java
---
@@ -374,6 +381,13 @@ public void endRecord()
Github user arina-ielchiieva commented on a diff in the pull request:
https://github.com/apache/drill/pull/666#discussion_r92194798
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/planner/sql/handlers/DropTableHandler.java
---
@@ -55,35 +57,48 @@ public DropTableHandl
Github user arina-ielchiieva commented on a diff in the pull request:
https://github.com/apache/drill/pull/666#discussion_r91951263
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/physical/impl/WriterRecordBatch.java
---
@@ -174,10 +174,15 @@ protected void setupNewSc
Github user arina-ielchiieva commented on a diff in the pull request:
https://github.com/apache/drill/pull/666#discussion_r92195010
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/planner/sql/handlers/SqlHandlerUtil.java
---
@@ -235,4 +235,15 @@ public static void unp
Github user arina-ielchiieva commented on a diff in the pull request:
https://github.com/apache/drill/pull/666#discussion_r91952394
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/rpc/user/UserSession.java ---
@@ -55,13 +61,37 @@
private OptionManager sessionOpt
Github user arina-ielchiieva commented on a diff in the pull request:
https://github.com/apache/drill/pull/666#discussion_r91952814
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/rpc/user/UserSession.java ---
@@ -207,25 +239,165 @@ public SchemaPlus getDefaultSchema(S
Github user arina-ielchiieva commented on a diff in the pull request:
https://github.com/apache/drill/pull/666#discussion_r92197849
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/store/parquet/ParquetRecordWriter.java
---
@@ -382,4 +396,20 @@ public void cleanup() th
Github user arina-ielchiieva commented on a diff in the pull request:
https://github.com/apache/drill/pull/666#discussion_r91953573
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/store/StorageStrategy.java
---
@@ -0,0 +1,82 @@
+/**
+ * Licensed to the Apache
Github user arina-ielchiieva commented on a diff in the pull request:
https://github.com/apache/drill/pull/666#discussion_r91959700
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/store/easy/json/JsonRecordWriter.java
---
@@ -82,6 +84,9 @@ public void init(Map writerO
Github user arina-ielchiieva commented on a diff in the pull request:
https://github.com/apache/drill/pull/666#discussion_r91952635
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/rpc/user/UserSession.java ---
@@ -207,25 +239,165 @@ public SchemaPlus getDefaultSchema(S
Github user arina-ielchiieva commented on a diff in the pull request:
https://github.com/apache/drill/pull/666#discussion_r92197145
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/store/StorageStrategy.java
---
@@ -0,0 +1,82 @@
+/**
+ * Licensed to the Apache
Github user arina-ielchiieva commented on a diff in the pull request:
https://github.com/apache/drill/pull/666#discussion_r92197400
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/store/dfs/WorkspaceSchemaFactory.java
---
@@ -478,10 +479,27 @@ private View getView(Dot
Github user arina-ielchiieva commented on a diff in the pull request:
https://github.com/apache/drill/pull/666#discussion_r91953946
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/store/dfs/WorkspaceSchemaFactory.java
---
@@ -523,7 +541,7 @@ public Table getTable(Stri
Github user arina-ielchiieva commented on a diff in the pull request:
https://github.com/apache/drill/pull/666#discussion_r91953026
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/rpc/user/UserSession.java ---
@@ -207,25 +239,165 @@ public SchemaPlus getDefaultSchema(S
Github user arina-ielchiieva commented on a diff in the pull request:
https://github.com/apache/drill/pull/666#discussion_r91952612
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/rpc/user/UserSession.java ---
@@ -207,25 +239,165 @@ public SchemaPlus getDefaultSchema(S
Github user arina-ielchiieva commented on a diff in the pull request:
https://github.com/apache/drill/pull/666#discussion_r91953272
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/rpc/user/UserSession.java ---
@@ -207,25 +239,165 @@ public SchemaPlus getDefaultSchema(S
Github user arina-ielchiieva commented on a diff in the pull request:
https://github.com/apache/drill/pull/666#discussion_r91952565
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/rpc/user/UserSession.java ---
@@ -207,25 +239,165 @@ public SchemaPlus getDefaultSchema(S
Github user arina-ielchiieva commented on a diff in the pull request:
https://github.com/apache/drill/pull/666#discussion_r92195973
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/rpc/user/UserSession.java ---
@@ -55,13 +61,37 @@
private OptionManager sessionOpt
Github user arina-ielchiieva commented on a diff in the pull request:
https://github.com/apache/drill/pull/666#discussion_r92196412
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/rpc/user/UserSession.java ---
@@ -207,25 +239,165 @@ public SchemaPlus getDefaultSchema(S
Github user arina-ielchiieva commented on a diff in the pull request:
https://github.com/apache/drill/pull/666#discussion_r92196815
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/store/AbstractSchema.java ---
@@ -248,4 +263,13 @@ public void dropTable(String tableName
Github user arina-ielchiieva commented on the issue:
https://github.com/apache/drill/pull/666
@paul-rogers
I have re-designed CTTAS, here is the main changes:
1. Temp table name is generated using UUID.randowmUUID().
2. All session temp tables are stored in session temp loc
Github user arina-ielchiieva commented on a diff in the pull request:
https://github.com/apache/drill/pull/666#discussion_r92196649
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/rpc/user/UserSession.java ---
@@ -207,25 +239,165 @@ public SchemaPlus getDefaultSchema(S
Paul Rogers created DRILL-5135:
--
Summary: TestMergeJoinWithSchemaChanges.testNumericTypes doesn't
Key: DRILL-5135
URL: https://issues.apache.org/jira/browse/DRILL-5135
Project: Apache Drill
Issu
[
https://issues.apache.org/jira/browse/DRILL-5135?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Paul Rogers resolved DRILL-5135.
Resolution: Invalid
Ahem... Turns out that there was an option buried in the query that was not
app
Github user jinfengni commented on a diff in the pull request:
https://github.com/apache/drill/pull/660#discussion_r93125431
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/compile/AbstractClassCompiler.java
---
@@ -74,9 +76,10 @@ protected String prefixLineNumbers(St
Github user jinfengni commented on a diff in the pull request:
https://github.com/apache/drill/pull/660#discussion_r93128101
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/compile/DrillJavaFileObject.java
---
@@ -67,6 +72,22 @@ public boolean isCompiled() {
Github user jinfengni commented on a diff in the pull request:
https://github.com/apache/drill/pull/660#discussion_r93123021
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/compile/ClassBuilder.java ---
@@ -0,0 +1,189 @@
+/**
+ * Licensed to the Apache Software
Github user jinfengni commented on a diff in the pull request:
https://github.com/apache/drill/pull/660#discussion_r93127937
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/compile/JaninoClassCompiler.java
---
@@ -58,5 +56,27 @@ public JaninoClassCompiler(ClassLoader
Github user nagarajanchinnasamy commented on a diff in the pull request:
https://github.com/apache/drill/pull/685#discussion_r93128266
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/expr/fn/impl/ContextFunctions.java
---
@@ -64,17 +65,45 @@ public void eval() {
Github user jinfengni commented on a diff in the pull request:
https://github.com/apache/drill/pull/660#discussion_r93122823
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/compile/ClassBuilder.java ---
@@ -0,0 +1,189 @@
+/**
+ * Licensed to the Apache Software
Robert Hou created DRILL-5136:
-
Summary: Some SQL statements fail when using Simba ODBC driver 1.3
Key: DRILL-5136
URL: https://issues.apache.org/jira/browse/DRILL-5136
Project: Apache Drill
Issu
Github user nagarajanchinnasamy commented on a diff in the pull request:
https://github.com/apache/drill/pull/685#discussion_r93128502
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/rpc/user/UserServer.java ---
@@ -343,10 +346,11 @@ public BitToUserHandshake
getHands
Github user nagarajanchinnasamy commented on a diff in the pull request:
https://github.com/apache/drill/pull/685#discussion_r93128753
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/rpc/user/UserServer.java ---
@@ -359,12 +363,14 @@ public BitToUserHandshake
getHands
Github user bitblender commented on a diff in the pull request:
https://github.com/apache/drill/pull/695#discussion_r93133495
--- Diff:
contrib/storage-hive/core/src/main/codegen/templates/ObjectInspectorHelper.java
---
@@ -172,48 +172,35 @@ public static JBlock getDrillObject(JCo
Github user paul-rogers commented on a diff in the pull request:
https://github.com/apache/drill/pull/660#discussion_r93133935
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/compile/ClassBuilder.java ---
@@ -0,0 +1,189 @@
+/**
+ * Licensed to the Apache Softwa
Github user paul-rogers commented on a diff in the pull request:
https://github.com/apache/drill/pull/660#discussion_r93134098
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/compile/DrillJavaFileObject.java
---
@@ -67,6 +72,22 @@ public boolean isCompiled() {
Github user paul-rogers commented on a diff in the pull request:
https://github.com/apache/drill/pull/660#discussion_r93134050
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/compile/ClassBuilder.java ---
@@ -0,0 +1,189 @@
+/**
+ * Licensed to the Apache Softwa
Github user paul-rogers commented on a diff in the pull request:
https://github.com/apache/drill/pull/660#discussion_r93133574
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/compile/AbstractClassCompiler.java
---
@@ -74,9 +76,10 @@ protected String prefixLineNumbers(
Github user paul-rogers commented on a diff in the pull request:
https://github.com/apache/drill/pull/660#discussion_r93134337
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/compile/JaninoClassCompiler.java
---
@@ -58,5 +56,27 @@ public JaninoClassCompiler(ClassLoade
Github user jinfengni commented on the issue:
https://github.com/apache/drill/pull/654
+1
LGTM.
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so,
Github user nagarajanchinnasamy commented on the issue:
https://github.com/apache/drill/pull/685
@arina-ielchiieva I have made the changes to:
1. Generate sessionId within the constructor of UserSession
2. Add a builder method in UserSession to construct
UserSessionContext
Hi Julian Hyde,
Thanks for your response. I am looking for the Drill way of doing it.
In fact I have coded session_id function exactly as one of other
ContextFunctions of Drill. I seem to be missing something :(
Best Regards,
Nagu.
On Mon, Dec 19, 2016 at 1:30 PM, Nagarajan Chinnasamy <
naga
GitHub user superbstreak opened a pull request:
https://github.com/apache/drill/pull/698
DRILL-5136: Server unable to prepare non SELECT queries
Currently, the server makes every incoming queries a limit 0 query during
server prepare. This is causing some non select queries to fail.
Github user jinfengni commented on a diff in the pull request:
https://github.com/apache/drill/pull/662#discussion_r93146424
--- Diff: exec/java-exec/src/test/java/org/apache/drill/TestBugFixes.java
---
@@ -221,4 +221,14 @@ public void testDRILL4884() throws Exception {
Github user jinfengni commented on the issue:
https://github.com/apache/drill/pull/660
+1
LGTM. Thanks for the PR!
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabl
Abhishek Girish created DRILL-5137:
--
Summary: Optimize count(*) queries on MapR-DB Binary Tables
Key: DRILL-5137
URL: https://issues.apache.org/jira/browse/DRILL-5137
Project: Apache Drill
I
Rahul Challapalli created DRILL-5138:
Summary: TopN operator on top of ~110 GB data set is very slow
Key: DRILL-5138
URL: https://issues.apache.org/jira/browse/DRILL-5138
Project: Apache Drill
Github user zbdzzg commented on a diff in the pull request:
https://github.com/apache/drill/pull/662#discussion_r93163164
--- Diff: exec/java-exec/src/test/java/org/apache/drill/TestBugFixes.java
---
@@ -221,4 +221,14 @@ public void testDRILL4884() throws Exception {
Github user asfgit closed the pull request at:
https://github.com/apache/drill/pull/662
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabl
Github user asfgit closed the pull request at:
https://github.com/apache/drill/pull/692
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabl
Github user asfgit closed the pull request at:
https://github.com/apache/drill/pull/679
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabl
Github user asfgit closed the pull request at:
https://github.com/apache/drill/pull/654
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabl
Github user asfgit closed the pull request at:
https://github.com/apache/drill/pull/660
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabl
Github user asfgit closed the pull request at:
https://github.com/apache/drill/pull/686
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabl
70 matches
Mail list logo