Trafodion Local-Lite

This checkout includes a local-lite build and runtime mode for native Trafodion SQL engine development.

local-lite removes Java, Maven, Hadoop, HDFS, HBase, Hive, DCS, REST, TrafCI, and Java client modules from the selected build path. The current supported runtime milestone is sqlci as a local single-process command-line SQL engine for compiler/executor-only SQL and minimal local RocksDB table smoke tests.

Local-lite is not a complete standalone database. It has a narrow RocksDB-backed local table path reachable from sqlci, but supported queries fall through normal compiler/executor execution and use local executor scan and insert TCBs. It has single-process local BEGIN/COMMIT/ROLLBACK support, and autocommit INSERT ... SELECT tuple flows publish atomically within one table. It has no atomic multi-table commit, indexes, privileges, JDBC/ODBC service path, DCS/REST stack, or HBase/HDFS/Hive runtime.

Full details are in:

plan/local-lite.md

The original Apache Trafodion project overview is preserved in:

plan/README.trafodion.md

Quick Build

Install native dependencies:

scripts/install-local-lite-deps.sh --dry-run
scripts/install-local-lite-deps.sh -y

Build local-lite:

OMPI_CXX=/usr/bin/g++ make local-lite

Quick SQLCI Run

For the current repository build layout:

export TRAF_HOME=$(pwd)/core/sqf
export TRAF_LOCAL_LITE=1
export TRAF_LOCAL_STORE_DIR=${TRAF_LOCAL_STORE_DIR:-/tmp/traf-local-lite-store}

SQL_LIBS=$(pwd)/core/sql/lib/linux/64bit/debug
SQF_LIBS=$(pwd)/core/sqf/export/lib64d
export LD_LIBRARY_PATH=$SQL_LIBS:$SQF_LIBS:${LD_LIBRARY_PATH:-}

$SQL_LIBS/sqlci

Example:

>>SELECT 1 FROM (VALUES(1)) AS t(x);
>>exit;

Minimal local table smoke example:

>>CREATE TABLE t(a INT, b VARCHAR(20));
>>INSERT INTO t VALUES (1, 'one'), (2, 'two');
>>SELECT * FROM t;
>>DROP TABLE t;
>>exit;

Quick Regress Run

After building the local-lite SQL binary, run the native TEST/EXPECTED lane without starting SQF, TMF, HBase, Hadoop, or ZooKeeper:

make local-lite-regress

Run selected cases with:

make local-lite-regress LOCAL_LITE_REGR_TESTS="001 003"

The runner prints the temporary artifact directory containing RAWnnn, LOGnnn, and DIFFnnn files. The cases and baselines live under core/sql/regress/localLite.

Use make all for the normal full Trafodion build.