Muhammad,
The join condition ‘a = b or (a is null && b is null)’ works. Internally,
this is converted to ‘a is not distinct from b’ which is processed by Drill.
For some reason, if the second form is directly supplied in the user query, it
is not working and ends up with the Cartesian join con
john li created DRILL-5506:
--
Summary: Apache Drill Querying data from compressed .zip file
Key: DRILL-5506
URL: https://issues.apache.org/jira/browse/DRILL-5506
Project: Apache Drill
Issue Type: Bug
Github user sohami commented on a diff in the pull request:
https://github.com/apache/drill/pull/809#discussion_r115860398
--- Diff: contrib/native/client/src/clientlib/drillClientImpl.cpp ---
@@ -854,75 +990,328 @@ void DrillClientImpl::waitForResults(){
}
}
Github user sohami commented on a diff in the pull request:
https://github.com/apache/drill/pull/809#discussion_r115614489
--- Diff: contrib/native/client/src/clientlib/drillClientImpl.cpp ---
@@ -854,75 +990,328 @@ void DrillClientImpl::waitForResults(){
}
}
Github user sohami commented on a diff in the pull request:
https://github.com/apache/drill/pull/809#discussion_r115877434
--- Diff: contrib/native/client/src/clientlib/utils.cpp ---
@@ -111,4 +111,52 @@ AllocatedBuffer::~AllocatedBuffer(){
m_bufSize = 0;
}
+
Github user sohami commented on a diff in the pull request:
https://github.com/apache/drill/pull/809#discussion_r115612998
--- Diff: contrib/native/client/src/clientlib/drillClientImpl.cpp ---
@@ -854,75 +990,328 @@ void DrillClientImpl::waitForResults(){
}
}
Github user sohami commented on a diff in the pull request:
https://github.com/apache/drill/pull/809#discussion_r115557153
--- Diff: contrib/native/client/src/clientlib/drillClientImpl.cpp ---
@@ -854,75 +990,328 @@ void DrillClientImpl::waitForResults(){
}
}
Github user sohami commented on a diff in the pull request:
https://github.com/apache/drill/pull/809#discussion_r115532000
--- Diff: contrib/native/client/src/clientlib/drillClientImpl.cpp ---
@@ -854,75 +990,328 @@ void DrillClientImpl::waitForResults(){
}
}
Github user sohami commented on a diff in the pull request:
https://github.com/apache/drill/pull/809#discussion_r115614854
--- Diff: contrib/native/client/src/clientlib/drillClientImpl.cpp ---
@@ -854,75 +990,328 @@ void DrillClientImpl::waitForResults(){
}
}
Github user sohami commented on a diff in the pull request:
https://github.com/apache/drill/pull/809#discussion_r115527833
--- Diff: contrib/native/client/src/clientlib/drillClientImpl.cpp ---
@@ -370,6 +453,33 @@ void DrillClientImpl::handleHShakeReadTimeout(const
boost::system::e
Github user sohami commented on a diff in the pull request:
https://github.com/apache/drill/pull/809#discussion_r115612782
--- Diff: contrib/native/client/src/clientlib/drillClientImpl.cpp ---
@@ -854,75 +990,328 @@ void DrillClientImpl::waitForResults(){
}
}
Github user sohami commented on a diff in the pull request:
https://github.com/apache/drill/pull/809#discussion_r11119
--- Diff: contrib/native/client/src/clientlib/drillClientImpl.cpp ---
@@ -854,75 +990,328 @@ void DrillClientImpl::waitForResults(){
}
}
Github user sohami commented on a diff in the pull request:
https://github.com/apache/drill/pull/809#discussion_r115530271
--- Diff: contrib/native/client/src/clientlib/drillClientImpl.cpp ---
@@ -495,26 +612,45 @@ connectionStatus_t
DrillClientImpl::handleAuthentication(const Dril
Github user sohami commented on a diff in the pull request:
https://github.com/apache/drill/pull/809#discussion_r115861013
--- Diff: contrib/native/client/src/clientlib/drillClientImpl.cpp ---
@@ -854,75 +990,328 @@ void DrillClientImpl::waitForResults(){
}
}
I think Muhammad may be trying to run his original query with IS NOT DISTINCT
FROM. That discussion got side-tracked into Cartesian joins because his query
was not getting planned and the error was about Cartesian join.
Muhammad, can you try with the equivalent version below ? You mentioned
Github user sudheeshkatkam commented on a diff in the pull request:
https://github.com/apache/drill/pull/827#discussion_r116116864
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/store/sys/PersistentStoreConfig.java
---
@@ -106,9 +113,14 @@ protected StoreConfigBuilde
Github user sudheeshkatkam commented on a diff in the pull request:
https://github.com/apache/drill/pull/827#discussion_r116116935
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/store/sys/store/InMemoryPersistentStore.java
---
@@ -15,28 +15,40 @@
* See the Lice
Github user sudheeshkatkam commented on a diff in the pull request:
https://github.com/apache/drill/pull/827#discussion_r116116220
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/store/sys/store/InMemoryPersistentStore.java
---
@@ -15,28 +15,40 @@
* See the Lice
Github user sudheeshkatkam commented on a diff in the pull request:
https://github.com/apache/drill/pull/827#discussion_r116116899
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/store/sys/store/InMemoryPersistentStore.java
---
@@ -15,28 +15,40 @@
* See the Lice
Github user sudheeshkatkam commented on a diff in the pull request:
https://github.com/apache/drill/pull/827#discussion_r116116596
--- Diff: exec/java-exec/src/main/resources/drill-module.conf ---
@@ -138,7 +138,10 @@ drill.exec: {
class:
"org.apache.drill.exec.store.sys.s
Github user sudheeshkatkam commented on a diff in the pull request:
https://github.com/apache/drill/pull/827#discussion_r116116310
--- Diff:
exec/java-exec/src/main/java/org/apache/drill/exec/store/sys/store/InMemoryPersistentStore.java
---
@@ -93,6 +105,14 @@ public void put(fina
I’m not sure why it isn’t working for you. Using Drill 1.10, here’s my output:
0: jdbc:drill:zk=local> alter session set
`planner.enable_nljoin_for_scalar_only` = false;
+---+-+
| ok | summary |
+-
But the query I provided failed to be planned because it's a cartesian
join, although I've set the option you mentioned to false. Is there a
reason why wouldn't Drill rules physically implement the logical join in my
query to a nested loop join ?
*-*
*Muhammad Gelbana*
http://
Rahul Challapalli created DRILL-5505:
Summary: Enabling exchanges increased the external sorts spill
count by 2 times
Key: DRILL-5505
URL: https://issues.apache.org/jira/browse/DRILL-5505
Project:
Github user kkhatua commented on the issue:
https://github.com/apache/drill/pull/827
@sudheeshkatkam & @ppadma ... please review and bless the PR if everything
looks fine.!
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well.
GitHub user paul-rogers opened a pull request:
https://github.com/apache/drill/pull/832
DRILL-5504: Vector validator to diagnose offset vector issues
Validates offset vectors in VarChar and repeated vectors. Validates the
special case of repeated VarChar vectors (two layers of of
Github user jinfengni commented on the issue:
https://github.com/apache/drill/pull/819
+1
The revised commit looks good to me. Thanks for taking effort to separate
the return type inference logic from function scope logic. You may consider
adding brief description of that cha
Provided `planner.enable_nljoin_for_scalar_only` is set to false, even without
an explicit join condition, the query should use the Cartesian join/nested loop
join.
-- Zelaine
On 5/11/17, 4:20 AM, "Anup Tiwari" wrote:
Hi,
I have one question here.. so if we have to use Cartesian
GitHub user Vlad-Storona opened a pull request:
https://github.com/apache/drill/pull/831
DRILL-5432: Added pcap-format support
See DRILL-5432 for details.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/mapr-demos/drill pcap-forma
Hi,
I have one question here.. so if we have to use Cartesian join in Drill
then do we have to follow some workaround like Shadi mention : adding a
dummy column on the fly that has the value 1 in both tables and then join
on that column leading to having a match of every row of the first table
wit
30 matches
Mail list logo
