Andrii Rosa arhimondr

arhimondr / gist:544683648eb4edacafd0ee68fceba410

Created September 17, 2018 23:16

	[WARNING] Rule 3: org.apache.maven.plugins.enforcer.RequireReleaseDeps failed with message:
	Snapshot dependencies are not allowed
	Found Banned Dependency: io.airlift:log:jar:0.174-SNAPSHOT
	Use 'mvn dependency:tree' to locate the source of the banned dependencies.
	[INFO] ------------------------------------------------------------------------
	[INFO] Reactor Summary:
	[INFO]
	[INFO] presto-root ........................................ SUCCESS [ 2.255 s]
	[INFO] presto-spi ......................................... SKIPPED
	[INFO] presto-plugin-toolkit .............................. SKIPPED

arhimondr / gist:968ba1804ba3ae5a12f91df41474b544

Created September 16, 2018 17:33

hive> ANALYZE TABLE <table> COMPUTE STATISTICS FOR COLUMNS;

arhimondr / gist:f32fca68e84ff098f67c84480f148d72

Created June 4, 2018 21:54

	----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
	- Output[rows] => [rows:bigint]
	- TableCommit[hive:HiveTransactionHandle{uuid=455b2996-33e3-48a4-bad3-9e3490bf4b40}:default.nation] => [rows:bigint]
	Collected statistics:
	aggregations =>
	NUMBER_OF_NULLS[nationkey] => [number_of_nulls-nationkey := "count"("count")]
	MIN[nationkey] => [min-nationkey := "min"("min")]
	MAX[nationkey] => [max-nationkey := "max"("max")]
	NUMBER_OF_DISTINCT_VALUES[nationkey] => [number_of_distinct_values-nationkey := "approx_distinct"("approx_distinct")]
	NUMBER_OF_NULLS[name] => [number_of_nulls-name := "count"("count_19")]

arhimondr / example.js

Created March 1, 2016 10:45

	var baseCreditPercent = 10;
	var promoCreditPercentFromThirtyToSixtyDays = 5;
	var promoCreditPercentFromSixtyDays = 3;

	var creditPercent = baseCreditPercent;

	if(30 <= creditTerm && creditTerm < 60){
	creditPercent = promoCreditPercentFromThirtyToSixtyDays;
	} else if(60 <= creditTerm){
	creditPercent = promoCreditPercentFromSixtyDays;