CHANGELOG.md

Version 0.27.0 - 2022-09-09

• github-232: [BUG] Column descriptions should be propagated in UNIONs
• github-233: [BUG] Missing Hadoop dependencies for S3, Delta, etc
• github-235: Implement new rest hook with fine control
• github-229: A build target should not fail if Impala "COMPUTE STATS" fails
• github-236: 'copy' target should not apply output schema
• github-237: jdbcQuery relation should use fields "sql" and "file" instead of "query"
• github-239: Allow optional SQL statement for creating jdbcTable
• github-238: Implement new 'jdbcCommand' target
• github-240: [BUG] Data quality checks in documentation should not fail on NULL values
• github-241: Throw an error on duplicate entity definitions
• github-220: Upgrade Delta-Lake to 2.0 / 2.1
• github-242: Switch to Spark 3.3 as default
• github-243: Use alternative Spark MS SQL Connector for Spark 3.3
• github-244: Generate project HTML documentation with optional external CSS file

Version 0.26.1 - 2022-08-03

• github-226: Upgrade to Spark 3.2.2
• github-227: [BUG] Flowman should not fail with field names containing "-", "/" etc
• github-228: Padding and truncation of CHAR(n)/VARCHAR(n) should be configurable

Version 0.26.0 - 2022-07-27

• github-202: Add support for Spark 3.3
• github-203: [BUG] Resource dependencies for Hive should be case-insensitive
• github-204: [BUG] Detect indirect dependencies in a chain of Hive views
• github-207: [BUG] Build should not directly fail if inferring dirty status fails
• github-209: [BUG] HiveViews should not trigger cascaded refresh during CREATE phase even when nothing is changed
• github-211: Implement new hiveQuery relation
• github-210: [BUG] HiveTables should be migrated if partition columns change
• github-208: Implement JDBC hook for database based semaphores
• github-212: [BUG] Hive views should not be migrated in RELAXED mode if only comments have changed
• github-214: Update ImpalaJDBC driver to 2.6.26.1031
• github-144: Support changing primary key for JDBC relations
• github-216: [BUG] Floats should be represented as FLOAT and not REAL in MySQL/MariaDB
• github-217: Support collations for creating/migrating JDBC tables
• github-218: [BUG] Postgres dialect should be used for Postgres JDBC URLs
• github-219: [BUG] SchemaMapping should retain incoming comments
• github-215: Support COLUMN STORE INDEX for MS SQL Server
• github-182: Support column descriptions in JDBC relations (SQL Server / Azure SQL)
• github-224: Support column descriptions for MariaDB / MySQL databases
• github-223: Support column descriptions for Postgres database
• github-205: Initial support Oracle DB via JDBC
• github-225: [BUG] Staging schema should not have comments

Breaking changes

We take backward compatibility very seriously. But sometimes a breaking change is needed to clean up code and to enable new features. This release contains some breaking changes, which are annoying but simple to fix. In order to respect null as keyword in YAML with a special semantics, some entities needed to be renamed, as described in the following table:

category	old kind	new kind
mapping	null	empty
relation	null	empty
target	null	empty
store	null	none
history	null	none

Version 0.25.1 - 2022-06-15

• github-195: [BUG] Metric "target_records" is not reset correctly after an execution phase is finished
• github-197: [BUG] Impala REFRESH METADATA should not fail when dropping views

Version 0.25.0 - 2022-05-31

• github-184: Only read in *.yml / *.yaml files in module loader
• github-183: Support storing SQL in external file in hiveView
• github-185: Missing _SUCCESS file when writing to dynamic partitions
• github-186: Support output mode OVERWRITE_DYNAMIC for Delta relation
• github-149: Support creating views in JDBC with new jdbcView relation
• github-190: Replace logo in documentation
• github-188: Log detailed timing information when writing to JDBC relation
• github-191: Add user provided description to quality checks
• github-192: Provide example queries for JDBC metric sink

Version 0.24.1 - 2022-04-28

• github-175: '--jobs' parameter starts way to many parallel jobs
• github-176: start-/end-date in report should not be the same
• github-177: Implement generic SQL schema check
• github-179: Update DeltaLake dependency to 1.2.1

Version 0.24.0 - 2022-04-05

• github-168: Support optional filters in data quality checks
• github-169: Support sub-queries in filter conditions
• github-171: Parallelize loading of project files
• github-172: Update CDP7 profile to the latest patch level
• github-153: Use non-privileged user in Docker image
• github-174: Provide application for generating YAML schema

Breaking changes

We take backward compatibility very seriously. But sometimes a breaking change is needed to clean up code and to enable new features. This release contains some breaking changes, which are annoying but simple to fix. In order to avoid YAML schema inconsistencies, some entities needed to be renamed, as described in the following table:

category	old kind	new kind
mapping	const	values
mapping	empty	null
mapping	read	relation
mapping	readRelation	relation
mapping	readStream	stream
relation	const	values
relation	empty	null
relation	jdbc	jdbcTable, jdbcQuery
relation	table	hiveTable
relation	view	hiveView
schema	embedded	inline

Version 0.23.1 - 2022-03-28

• github-154: Fix failing migration when PK requires change due to data type
• github-156: Recreate indexes when data type of column changes
• github-155: Project level configs are used outside job
• github-157: Fix UPSERT operations for SQL Server
• github-158: Improve non-nullability of primary key column
• github-160: Use sensible defaults for default documenter
• github-161: Improve schema caching during execution
• github-162: ExpressionColumnCheck does not work when results contain NULL values
• github-163: Implement new column length quality check

Version 0.23.0 - 2022-03-18

• github-148: Support staging table for all JDBC relations
• github-120: Use staging tables for UPSERT and MERGE operations in JDBC relations
• github-147: Add support for PostgreSQL
• github-151: Implement column level lineage in documentation
• github-121: Correctly apply documentation, before/after and other common attributes to templates
• github-152: Implement new 'cast' mapping

Version 0.22.0 - 2022-03-01

• Add new sqlserver relation
• Implement new documentation subsystem
• Change default build to Spark 3.2.1 and Hadoop 3.3.1
• Add new drop target for removing tables
• Speed up project loading by reusing Jackson mapper
• Implement new jdbc metric sink
• Implement schema cache in Executor to speed up documentation and similar tasks
• Add new config variables flowman.execution.mapping.schemaCache and flowman.execution.relation.schemaCache
• Add new config variable flowman.default.target.verifyPolicy to ignore empty tables during VERIFY phase
• Implement initial support for indexes in JDBC relations

Version 0.21.2 - 2022-02-14

• Fix importing projects

Version 0.21.1 - 2022-01-28

• flowexec now returns different exit codes depending on the processing result

Version 0.21.0 - 2022-01-26

• Fix wrong dependencies in Swagger plugin
• Implement basic schema inference for local CSV files
• Implement new stack mapping
• Improve error messages of local CSV parser

Version 0.20.1 - 2022-01-06

• Implement detection of dependencies introduced by schema

Version 0.20.0 - 2022-01-05

• Fix detection of Derby metastore to truncate comment lengths.
• Add new config variable flowman.default.relation.input.columnMismatchPolicy (default is IGNORE)
• Add new config variable flowman.default.relation.input.typeMismatchPolicy (default is IGNORE)
• Add new config variable flowman.default.relation.output.columnMismatchPolicy (default is ADD_REMOVE_COLUMNS)
• Add new config variable flowman.default.relation.output.typeMismatchPolicy (default is CAST_ALWAYS)
• Improve handling of _SUCCESS files for detecting (non-)dirty directories
• Implement new merge target
• Implement merge operation for Delta relations
• Implement merge operation for JDBC relations (only for some databases, i.e. MS SQL)
• Add new config variable flowman.execution.target.useHistory (default is false)
• Change the semantics of config variable flowman.execution.target.forceDirty (default is false)
• Add new -d / --dirty option for explicitly marking individual targets as dirty

Version 0.19.0 - 2021-12-13

• Add build profile for Hadoop 3.3
• Add build profile for Spark 3.2
• Allow SQL expressions as dimensions in aggregate mapping
• Update Hive views when the resulting schema would change
• Add new mapping cache command to FlowShell
• Support embedded connection definitions
• Much improved Flowman History Server
• Fix wrong metric names with TemplateTarget
• Implement more template types for connection, schema, dataset, assertion and measure
• Implement new measure target for creating custom metrics for measuring data quality
• Add new config option flowman.execution.mapping.parallelism

Version 0.18.0 - 2021-10-13

• Improve automatic schema migration for Hive and JDBC relations
• Improve support of CHAR(n) and VARCHAR(n) types. Those types will now be propagated to Hive with newer Spark versions
• Support writing to dynamic partitions for file relations, Hive tables, JDBC relations and Delta tables
• Fix the name of some config variables (floman.* => flowman.*)
• Added new config variables flowman.default.relation.migrationPolicy and flowman.default.relation.migrationStrategy
• Add plugin for supporting DeltaLake (https://delta.io), which provides deltaTable and deltaFile relation types
• Fix non-deterministic column order in schema mapping, values mapping and values relation
• Mark Hive dependencies has 'provided', which reduces the size of dist packages
• Significantly reduce size of AWS dependencies in AWS plugin
• Add new build profile for Cloudera CDP-7.1
• Improve Spark configuration of LocalSparkSession and TestRunner
• Update Spark 3.0 build profile to Spark 3.0.3
• Upgrade Impala JDBC driver from 2.6.17.1020 to 2.6.23.1028
• Upgrade MySQL JDBC driver from 8.0.20 to 8.0.25
• Upgrade MariaDB JDBC driver from 2.2.4 to 2.7.3
• Upgrade several Maven plugins to latest versions
• Add new config option flowman.workaround.analyze_partition to workaround CDP 7.1 issues
• Fix migrating Hive views to tables and vice-versa
• Add new option "-j " to allow running multiple job instances in parallel
• Add new option "-j " to allow running multiple tests in parallel
• Add new uniqueKey assertion
• Add new schema assertion
• Update Swagger libraries for swagger schema
• Implement new openapi plugin to support OpenAPI 3.0 schemas
• Add new readHive mapping
• Add new simpleReport and report hook
• Implement new templates

Version 0.17.1 - 2021-06-18

• Bump CDH version to 6.3.4
• Fix scope of some dependencies
• Update Spark to 3.1.2
• Add new values relation

Version 0.17.0 - 2021-06-02

• New Flowman Kernel and Flowman Studio application prototypes
• New ParallelExecutor
• Fix before/after dependencies in count target
• Default build is now Spark 3.1 + Hadoop 3.2
• Remove build profiles for Spark 2.3 and CDH 5.15
• Add MS SQL Server plugin containing JDBC driver
• Speed up file listing for file relations
• Use Spark JobGroups
• Better support running Flowman on Windows with appropriate batch scripts

Version 0.16.0 - 2021-04-23

• Add logo to Flowman Shell
• Fix name of config option flowman.execution.executor.class
• Add new groupedAggregate mapping
• Reimplement target ordering, configurable via flowman.execution.scheduler.class
• Implement new assertions columns and expression

Version 0.15.0 - 2021-03-23

• New configuration variable floman.default.target.rebalance
• New configuration variable floman.default.target.parallelism
• Changed behaviour: The mergeFile target now does not assume any more that the target is local. If you already use mergeFiles with a local file, you need to prefix the target file name with file://.
• Add new -t argument for selectively building a subset of targets
• Remove example-plugin
• Add quickstart guide
• Add new "flowman-parent" BOM for projects using Flowman
• Move com.dimajix.flowman.annotations package to com.dimajix.flowman.spec.annotations
• Add new log redaction
• Integrate Scala scode coverage analysis
• assemble will fail when trying to use non-existing columns
• Move swagger and json schema support into separate plugins
• Change default build to Spark 3.0 and Hadoop 3.2
• Update Spark to 3.0.2
• Rename class Executor to Execution - watch your plugins!
• Implement new configurable Executor class for executing build targets.
• Add build profile for Spark 3.1.x
• Update ScalaTest to 3.2.5 - watch your unittests for changed ScalaTest API!
• Add new case mapping
• Add new --dry-run command line option
• Add new mock and null mapping types
• Add new mock relation
• Add new values mapping
• Add new values dataset
• Implement new testing capabilities
• Rename update mapping to upsert mapping, which better describes its functionality
• Introduce new VALIDATE phase, which is executed even before CREATE phase
• Implement new validate and verify targets
• Implement new deptree command in Flowman shell

Version 0.14.2 - 2020-10-12

• Upgrade to Spark 2.4.7 and Spark 3.0.1
• Clean up dependencies
• Disable build of Docker image
• Update examples

Version 0.14.1 - 2020-09-28

• Fix dropping of partitions which could cause issues on CDH6

Version 0.14.0 - 2020-09-10

• Fix AWS plugin for Hadoop 3.x
• Improve setup of logging
• Shade Velocity for better interoperability with Spark 3
• Add new web hook facility in namespaces and jobs
• Existing targets will not be overwritten anymore by default. Either use the --force command line option, or set the configuration property flowman.execution.target.forceDirty to true for the old behaviour.
• Add new command line option --keep-going
• Implement new com.dimajix.spark.io.DeferredFileCommitProtocol which can be used by setting the Spark configuration parameter spark.sql.sources.commitProtocolClass
• Add new flowshell application

Version 0.13.1 - 2020-07-14

• Code improvements
• Do not implicitly set SPARK_MASTER in configuration
• Add support for CDH6
• Add support for Spark 3.0
• Improve support for Hadoop 3.x

Version 0.13.0 - 2020-04-21

• Refactor Maven module structure
• Implement new Scala DSL for creating projects
• Fix ordering bug in target execution
• Merge migrate phase into create phase
• Rename input field to mapping in most targets
• Lots of minor code improvements

Version 0.12.2 - 2020-04-06

• Fix type coercion of DecimalTypes

Version 0.12.1 - 2020-01-15

• Improve support for Swagger Schema
• Fix infinite loop in recursiveSql

Version 0.12.0 - 2020-01-09

• Add new RecursiveSqlMapping
• Refactor describe method of mappings
• Fix TemplateRelation to return correct partitions and fields
• Add filter attribute to many mappings

Version 0.11.6 - 2019-12-17

• Improve build dependency management with DataSets

Version 0.11.5 - 2019-12-16

• Update to newest Swagger V2 parser
• Workaround for bug in Swagger parser for enums
• Tidy up logging

Version 0.11.4 - 2019-12-11

• Remove HDFS directories when dropping Hive table partitions

Version 0.11.3 - 2019-12-06

• Improve migrations of HiveUnionTable
• Improve schema support in copy target

Version 0.11.2 - 2019-12-02

• Add new earliest mapping

Version 0.11.1 - 2019-11-29

• Improve Hive compatibility of SQL generator for UNION statements

Version 0.11.0 - 2019-11-28

• Add support for Spark 3.0 preview
• Remove HBase plugin
• Add optional filter to readRelation mapping
• Improve Hive compatibility of SQL generator for ORDER BY statements
• Fix target table search in Hive Union Table

Version 0.10.2 - 2019-11-18

• Improve Impala catalog support

Version 0.10.1 - 2019-11-14

• Add error output to extractJson mapping

Version 0.10.0 - 2019-11-05

• Add new hiveUnionTable relation
• Add new union schema
• Support nested columns in deduplication
• Support nested Hive VIEWs
• Support Spark 2.4.4

Version 0.9.1 - 2019-10-10

• Fix wrong Spark application name if configured via Spark config

Version 0.9.0 - 2019-10-08

• Complete overhaul of job execution. No tasks anymore
• Improve Swagger schema support

Version 0.8.3 - 2019-09-16

• Add configuration option for column insert position of historize mapping

Version 0.8.2 - 2019-08-29

• Add optional filter condition to latest mapping

Version 0.8.1 - 2019-08-29

• Improve generation of SQL code containing window functions

Version 0.8.0 - 2019-08-28

• Add new metric system
• Add Hive view generation from mappings
• Support for Hadoop 3.1 and 3.2 (without Hive)
• Add historize mapping

Version 0.7.1 - 2019-07-22

• Fix build with CDH-5.15 profile

Version 0.7.0 - 2019-07-22

• Implement initial REST server
• Implement initial prototype of UI
• Implement new datasets for new tasks (copy/compare/...)

Version 0.6.5 -

• Add support for checkpoint directory

Verison 0.6.4 - 2019-06-20

• Implement column renaming in projections

Verison 0.6.3 - 2019-06-17

• CopyRelationTask also performs projection

Version 0.6.2 - 2019-06-12

• explode mapping supports simple data types

Version 0.6.1 - 2019-06-11

• Fix NPE in ShowRelationTask

Version 0.6.0 - 2019-06-11

• Add multiple relations to showRelation task
• github-33: Add new unit mapping
• github-34: Fix NPE in Swagger schema reader
• github-36: Add new explode mapping

Version 0.5.0 - 2019-05-28

• github-32: Improve handling of nullable structs
• github-30: Refactoring of whole specification handling
• github-30: Add new template mapping
• Add new flatten entry in assembler
• Implement new flatten mapping
• github-31: Fix handling of local project definition in flowexec

Version 0.4.1 - 2019-05-11

• Add parameters to "job run" CLI
• Fix error handling of failing "build" and "clean" tasks

Version 0.4.0 - 2019-05-08

• Add support for Spark 2.4.2
• Add new assemble mapping
• Add new conform mapping

Version 0.3.0 - 2019-03-20

• Add null format for Spark
• Add deployment

Version 0.1.2 - 2018-11-05

• Update to Spark 2.3.2
• Small fixes

Version 0.1.1 - 2018-09-14

Small fixes

Version 0.1.0 - 2018-07-20

Initial release