Adding to the above: Workflow Manager has become GA with Ambari 2.5+. Prior to that it was tech preview in Ambari 2.4.x. If you are using a previous version, either upgrade your Ambari (which may be done independantly of HDP) or use Oozie directly. ... View more

@Abraham Abraham Do you mean the maximum size of each file while the table may have multiple files or maximum size of the table? For maximum file size, you cannot do much except for a block size (each file having multiple blocks). There is no limit to a file size. However, you can limit the size of data in each directory using HDFS disk quota. So assume you have external table at /user/mytable Now you can the quota for this directory to be 1TB for example. In this case you will limit the table size to be 1TB. But you can of course have multiple files. ... View more