RelExpr.cpp

Clone Tools
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
jira TRAFODION-3157 Add support for BINARY/VARBINARY datatype

Spec attached to jira.

new test regress/seabase/TEST004 added.

  1. … 86 more files in changeset.
[TRAFODION-3220] Executor GUI

Adding the ability to display query execution with the "display"

command in Trafodion (sqlci only, requires an X Windows display,

just as the compiler GUI does).

  1. … 44 more files in changeset.
Merge [TRAFODION-2901] Self-reference Holloween problem fix PR-1581

[TRAFODION-2901] add explanation

TRAFODION-3086 Further enhancements to 'DDL on Hive objects'

-- Hive CTAS enhancements

-- CTAS will do create through Hive and insert...select in Traf

-- a cqd can be set if CTAS need to be passed in completely to Hive

-- CTAS 'no load' option can be used to create a Hive

table LIKE a traf table.

Older 'create hive like traf' is removed.

-- explain for CTAS to show ddl, insert...select, upd...stats stmts

-- Truncate enhancements.

-- traf: purgedata, truncate, truncate table

-- Hive: truncate, truncate table

-- 'if exists' option has been added

-- Hive truncate is through new exeutil operator

-- older operator uses LOB interface to clear data.

Maintained as Legacy operator, will be removed.

-- new operator uses Hive to truncate tables

-- explain for truncate to show trunc query that will be sent

-- removed obsolete parallel label op

-- removed obsolete purgedata (fast delete) op

  1. … 30 more files in changeset.
TRAFODION-3086 Traf support for DDL operations on Hive objects

-- Support for TRAFODION-3086. Details in document attached to jira.

Other changes:

-- support for "if not exists", "if exists" clause for create/drop view

-- Support for: truncate T, truncate table T.

-- same as purgedata

-- showddl <tab>, detail

-- unregister hive schema <sch>

-- will unregister all objects in specified schema

-- Support for "if not registered", "if registered" clauss for

register/unregister command.

  1. … 90 more files in changeset.
[TRAFODION-2901] fix core dump

[TRAFODION-2901] take one in column list as source for output

[TRAFODION-2901] Self-reference Holloween problem fix

[TRAFODION 3047] Cannot get right result using prepare statement with dynamic parameters

Merge [TRAFODION-3031] PR 1530 Fix two issues with nested subquery plans

  1. … 1 more file in changeset.
merge [TRAFODION-3021] union, intersect, except should be cacheable

[TRAFODION-3031] Fix two issues with nested subquery plans

  1. … 3 more files in changeset.
Merge [TRAFODION-3028] Support CONTROL QUERY SHAPE (CQS) for Hive insert PR-1525

  1. … 4 more files in changeset.
[TRAFODION-3028] Support CONTROL QUERY SHAPE (CQS) for Hive insert

Adding fast_extract() and hive_insert() CQS operator syntax to be able to force shapes of Hive insert statements.

Example:

control query shape hive_insert(cut);

explain insert into hive.hive.t values(1,1);

Note: I don't think this fix works for UNLOAD, since that seems to be

an "ExeUtil" statement that gets executed in two phases.

  1. … 5 more files in changeset.
[TRAFODION-3021] union, intersect, except should be cacheable

  1. … 1 more file in changeset.
[TRAFODION-2983] Be careful to preserve inputs needed for output computation

  1. … 1 more file in changeset.
More reworks based on Hans' comments (missed one place)

[TRAFODION-2969] Fix interaction of [first n] etc. with subqueries

  1. … 4 more files in changeset.
[TRAFODION-2840] Make [first n] with ORDER BY views non-updatable

  1. … 6 more files in changeset.
Merge branch 'master' into trafodion-2733

  1. … 10 more files in changeset.
JIRA TRAFODION-2834 Streamline supported xn access modes

traf DTM only supports 'read committed access' for selects

and 'set transaction ' stmts.

With this checkin, only those 2 options will be allowed.

All other access options will return an error.

Read uncommitted access will be treated as read committed.

  1. … 60 more files in changeset.
[TRAFODION-2733] BMO quota changes

To ensure BMO quota assignment works even when the estimates are way off.

Introduced a CQD BMO_MEMORY_ESTIMATE_OUTLIER_FACTOR. When a BMO memory

estimate exceeds BMO_MEMORY_LIMIT_PER_NODE_IN_MB by this factor,

the BMO memory estimate for the operator is reset to

BMO_MEMORY_LIMIT_PER_NODE_IN_MB * BMO_MEMORY_ESTIMATE_OUTLIER_FACTOR.

Then BMO memory estimate and the quota is assigned based on the

revised estimate.

  1. … 27 more files in changeset.
[TRAFODION-2822] Make [first n] views non-updatable; prevent bad MERGE plans

  1. … 1 more file in changeset.
Merge [TRAFODION-2758] PR-1250 Sort operator that uses TopN sort at runtime is not accuratelt determined at compile time

  1. … 9 more files in changeset.
TRAFODION-2731 CodeCleanup: Phase 4. Remove legacy/obsolete pragmas

  1. … 392 more files in changeset.
[TRAFODION-2758] Sort operator that uses TopN sort at runtime is not accurately determined at compile time

This commit includes fixes for these three issues. Please see JIRA for a description of each fix.

[TRAFODION-2758] Sort operator that uses TopN sort at runtime is not accurately determined at compile time

[TRAFODION-2759] Use of rowset with large memory leads to various errors at runtime

[TRAFODION-2760] hbase cache blocks is OFF for broad table with narrow index

[TRAFODION-2758]

comexe/ComTdbSort.cpp

comexe/ComTdbSort.h

executor/ex_sort.cpp

generator/GenExplain.cpp

generator/GenPreCode.cpp

generator/GenRelMisc.cpp

optimizer/RelExpr.cpp

[TRAFODION-2759]

bin/SqlciErrors.txt

generator/GenRelPackedRows.cpp

sqlcomp/DefaultConstants.h

sqlcomp/nadefaults.cpp

[TRAFODION-2760]

generator/GenRelScan.cpp

  1. … 11 more files in changeset.
[TRAFODION-2733] Provide an improved memory quota assignment for big memory operators (BMO)

Changes as per review

  1. … 12 more files in changeset.
Provision to tune the BMO memory quota.

Currently, BMO quota is allocated based on memory estimate of the BMO operator

and the BMO_MEMORY_LIMIT_PER_NODE. Introducing a new CQD BMO_MEMORY_EQUAL_QUOTA_SHARE_RATIO

to determine how much of BMO_MEMORY_LIMITE_PER_NODE is divided equally between

BMO operators and the rest would depend upon the memory estimate. This ratio is set

to 0.5 by default. Changing it to 0 will get the current behavior. This change is needed

to get better BMO quota allocation when the memory estimate goes awry for certain types of query.

(cherry picked from commit f3dd246b50905f1e83e852f1fb2e556dc4189761)

Conflicts:

core/sql/optimizer/RelExpr.cpp

  1. … 2 more files in changeset.
Ensured that CQD NUM_ESP_FRAGMENTS can take value upto 8. Removed the environment variable concept to set the number of esp fragments. Removed the CQDs ESP_NUM_FRAGMENTS_WITH_QUOTAS and ESP_MULTI_FRAGMENT_QUOTAS. Use the corresponding CQD ESP_NUM_FRAGMENTS and ESP_MUTLI_FRAGMENT instead (cherry picked from commit 72534e89633f3d4b8a61ab26d471aaa8b7f3e12a)

Conflicts:

core/sql/executor/ex_frag_rt.cpp

core/sql/executor/ex_frag_rt.h

core/sql/generator/GenRelMisc.cpp

  1. … 45 more files in changeset.