[
https://issues.apache.org/jira/browse/LENS-170?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14260093#comment-14260093
]
Jaideep Dhok commented on LENS-170:
-----------------------------------
[~sushilmohanty] Whether query without filters is expensive depends on the
table size. Forcing users to add filters on very small tables is not user
friendly.
Also, in the patch I see that we are merely checking the number of filters.
That could be easily bypassed by a query like this -
SELECT * FROM SOMETABLE WHERE <time_range_condition> AND 1 = 1 AND 2 = 2
How would we guard against this?
> Skip queries without filter in jdbc driver
> -------------------------------------------
>
> Key: LENS-170
> URL: https://issues.apache.org/jira/browse/LENS-170
> Project: Apache Lens
> Issue Type: Improvement
> Components: driver-jdbc
> Affects Versions: 2.0
> Reporter: Sushil Mohanty
> Assignee: Sushil Mohanty
> Attachments: LENS-170-1.patch, LENS-170.patch
>
>
> Queries without filters are expensive to run using jdbc driver. Such queries
> can be answered only via hive.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
