[
https://issues.apache.org/jira/browse/DRILL-6982?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16749392#comment-16749392
]
Bridget Bevens commented on DRILL-6982:
---------------------------------------
Hi [~kkhatua],
Based on https://issues.apache.org/jira/browse/DRILL-6834, Drill doc was
reviewed and approved. The Drill documentation states the following about the
the exec.return_result_set_for_ddl option:
_“When set to false, Drill returns the affected row count, and the result set
is null.”_
So, based on this JIRA, seems that Drill is not having the expected behavior.
I’m guessing this JIRA is asking for Drill to return the affected rows count
for DDL statements when the exec.return_result_set_for_ddl option is set to
false.
If you set the option to false and run the following create table command:
CREATE TABLE tmp.`name_key2` (N_NAME, N_NATIONKEY) AS SELECT N_NATIONKEY,
N_NAME FROM
dfs.`/root/drill-1.15/apache-drill-1.15.0-SNAPSHOT/sample-data/nation.parquet`;
Drill creates the table, but returns the following instead of the affected row
count:
No rows affected (2.714 seconds)
Thanks,
Bridget
> Affected rows count is not returned by Drill if return_result_set_for_ddl is
> false
> ----------------------------------------------------------------------------------
>
> Key: DRILL-6982
> URL: https://issues.apache.org/jira/browse/DRILL-6982
> Project: Apache Drill
> Issue Type: Bug
> Affects Versions: 1.15.0
> Reporter: Anton Gozhiy
> Priority: Major
>
> *Prerequisites:*
> {code:sql}
> set `exec.query.return_result_set_for_ddl`= false;
> {code}
> *Query:*
> {code:sql}
> create table dfs.tmp.`nation as select * from cp.`tpch/nation.parquet`;
> {code}
> *Expected result:*
> Drill should return the number of affected rows (25 in this case)
> *Actual Result:*
> The table was created, but affected rows count wasn't returned:
> {noformat}
> No rows affected (1.755 seconds)
> {noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
