[
https://issues.apache.org/jira/browse/DRILL-4099?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15011980#comment-15011980
]
Khurram Faraaz commented on DRILL-4099:
---------------------------------------
This can not be reproduced on Drill 1.3 sys.version a639c51c.
All the three queries below return expected results.
{code}
0: jdbc:drill:schema=dfs.tmp> select c1 from inNstedDirAutoPrtn LIMIT 65536;
+-----------+
| c1 |
+-----------+
| -1710 |
| 164300 |
| -884 |
...
Another query that projects ALL columns
0: jdbc:drill:schema=dfs.tmp> select * from inNstedDirAutoPrtn LIMIT 65536;
+-----------+----------+-----+-------------------------------------------------------+--------------------------+-------------+--------+------------------+---------------+
| c1 | c2 | c3 | c4
| c5 | c6 | c7 | c8 |
c9 |
+-----------+----------+-----+-------------------------------------------------------+--------------------------+-------------+--------+------------------+---------------+
| -1710 | 221632 | GA |
DXXXXXXXXXXXXXXXXXXXXXXXXXEXXXXXXXXXXXXXXXXXXXXXXXXF | 2014-06-02 00:28:02.434
| 1962-06-04 | false | 1.44804901984E8 | 16:38:18.370 |
| 164300 | 819680 | MA |
AXXXXXXXXXXXXXXXXXXXXXXXXXCXXXXXXXXXXXXXXXXXXXXXXXXB | 2014-06-02 00:28:02.421
| 1991-06-20 | false | 4.7471347117E8 | 20:31:55.240 |
...
Another query over parquet data, note that 65,536 rows were returned. Table had
50M rows in it.
0: jdbc:drill:schema=dfs.tmp> select col1 from CTAS_ONE_MILN_RWS_PER_GROUP
limit 65536;
...
| -30676 |
| -53348 |
| 32296 |
| -58616 |
| 62520 |
...
| 78701 |
| 197556 |
| 163535 |
| 168020 |
+---------+
65,536 rows selected (3.085 seconds)
{code}
> DRILL QUERY LIMIT ERROR
> -----------------------
>
> Key: DRILL-4099
> URL: https://issues.apache.org/jira/browse/DRILL-4099
> Project: Apache Drill
> Issue Type: Bug
> Components: Functions - Drill
> Affects Versions: 1.1.0
> Reporter: huntersjm
>
> I query `select attr from table limit 65536`, then I get error :
> org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
> IndexOutOfBoundsException: index: 131072, length: 2 (expected: range(0,
> 131072)) Fragment 0:0
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
