• File size measurements show the distribution of size of files.
• Files are classified in four categories based on their size (lines of code): 1-100 (very small files), 101-200 (small files), 201-500 (medium size files), 501-1000 (long files), 1001+(very long files).
• It is a good practice to keep files small. Long files may become "bloaters", code that have increased to such gargantuan proportions that they are hard to work with.

• There are 388 files with 30,645 lines of code.
• 2 very long files (3,270 lines of code)
• 4 long files (3,054 lines of code)
• 25 medium size files (7,211 lines of codeclsfd_ftr_w_mp_ins)
• 53 small files (7,226 lines of code)
• 304 very small files (9,884 lines of code)

There are 358 files with lines longer than 120 characters. In total, there are 5405 long lines.

File	# lines	# units	# long lines
apache-hawq-nav.erb in book/master_middleman/source/subnavs	963	-	525
parameter_definitions.html.md.erb in markdown/reference/guc	2130	-	284
HivePXF.html.md.erb in markdown/pxf	754	-	87
using_plpython.html.md.erb in markdown/plext	550	-	83
SELECT.html.md.erb in markdown/reference/sql	338	-	83
logfiles.html.md.erb in markdown/admin	182	-	79
using_pljava.html.md.erb in markdown/plext	787	-	73
HAWQDataTypes.html.md.erb in markdown/reference	104	-	69
PXFExternalTableandAPIReference.html.md.erb in markdown/pxf	1140	-	63
CREATE-TABLE.html.md.erb in markdown/reference/sql	322	-	63
ddl-partition.html.md.erb in markdown/ddl	342	-	62
hawqload.html.md.erb in markdown/reference/cli/admin_utilities	306	-	61
defining-queries.html.md.erb in markdown/query	361	-	60
functions-operators.html.md.erb in markdown/query	362	-	60
kerberos-userauth.html.md.erb in markdown/clientaccess	280	-	57
HDFSFileDataPXF.html.md.erb in markdown/pxf	321	-	55
CharacterSetSupportReference.html.md.erb in markdown/reference	412	-	54
ranger-policy-creation.html.md.erb in markdown/ranger	202	-	49
ranger-integration-config.html.md.erb in markdown/ranger	161	-	49
HDFSWritablePXF.html.md.erb in markdown/pxf	299	-	48
hawq_toolkit.html.md.erb in markdown/reference/toolkit	171	-	48
query-profiling.html.md.erb in markdown/query	171	-	44
about_statistics.html.md.erb in markdown/datamgmt	140	-	43
ddl-table.html.md.erb in markdown/ddl	96	-	42
pg_dump.html.md.erb in markdown/reference/cli/client_utilities	166	-	42
YARNIntegration.html.md.erb in markdown/resourcemgmt	176	-	38
ALTER-TABLE.html.md.erb in markdown/reference/sql	294	-	38
TroubleshootingPXF.html.md.erb in markdown/pxf	223	-	37
using_plpgsql.html.md.erb in markdown/plext	206	-	37
basichawqadmin.html.md.erb in markdown/tutorial/gettingstarted	126	-	36
client_auth.html.md.erb in markdown/clientaccess	125	-	35
aws-config.html.md.erb in markdown/install	86	-	33
HDFSConfigurationParameterReference.html.md.erb in markdown/reference	246	-	33
kerberos-securehdfs.html.md.erb in markdown/clientaccess	163	-	32
CREATE-RESOURCE-QUEUE.html.md.erb in markdown/reference/sql	90	-	32
CREATE-FUNCTION.html.md.erb in markdown/reference/sql	130	-	32
BackingUpandRestoringHAWQDatabases.html.md.erb in markdown/admin	261	-	31
query-performance.html.md.erb in markdown/query	119	-	30
ALTER-RESOURCE-QUEUE.html.md.erb in markdown/reference/sql	83	-	30
ambari-rest-api.html.md.erb in markdown/admin	112	-	28
pg_restore.html.md.erb in markdown/reference/cli/client_utilities	185	-	28
GRANT.html.md.erb in markdown/reference/sql	113	-	28
CREATE-AGGREGATE.html.md.erb in markdown/reference/sql	108	-	27
managing_resources_bestpractices.html.md.erb in markdown/bestpractices	94	-	26
dataandscripts.html.md.erb in markdown/tutorial/gettingstarted	180	-	26
ClusterExpansion.html.md.erb in markdown/admin	163	-	26
pg_am.html.md.erb in markdown/reference/catalog	31	-	26
CREATE-OPERATOR-CLASS.html.md.erb in markdown/reference/sql	111	-	26
CREATE-ROLE.html.md.erb in markdown/reference/sql	132	-	26
basicdbadmin.html.md.erb in markdown/tutorial/gettingstarted	148	-	25