Reporting with Hadoop - Big Data Made Easy: A Working Guide to the Complete Hadoop Toolset - page 346

Shown in Figure 11-21 , the new Hive-based rule is now called “Hive Date DD MM YYYY” and will be used to
check Hive table-based dates. Note that the connection type has been set to Hive. The actual regular expression rule,
which appears at the bottom right, basically checks a date column to confirm that it contains a date of the form that's
either 01/12/2014 or 01-12-2014.
Figure 11-21. Regular expression rule for dates
You can create SQL-based data-quality rules as well. For example, to do so, I right-click the SQL folder under
Libraries, then choose Rules within the Repository pane and select the option New Business Rule. Figures 11-22
and 11-23 show two rules I created to test column values.
Figure 11-22. SQL data-quality rule for “amount” column