Width_Bucket function is not support in ESRI Spatial Framework for Hadoop. What are the alternatives fro this function?

mahipal_ramidi — Mon, 08 Aug 2016 03:01:09 GMT

Re: Width_Bucket function is not support in ESRI Spatial Framework for Hadoop. What are the alternatives fro this function?

cstanca — Tue, 09 Aug 2016 04:04:38 GMT

Best is to write a Java UDF for Hive, however, you can actually write WIDTH_BUCKET in SQL if you know your number of buckets and assume that is static for your histogram. Her is an example:

SELECT whatever, CASE WHEN(whatever)>=${hiveconf:mymin} AND (t.tiv)<=${hiveconf:mymax}

THEN CASEWHENfloor((whatever)/((${hiveconf:mymax}–

${hiveconf:mymin})/${ hiveconf:mybuckets} )+ 1)>${ hiveconf:mybuckets}

THEN floor((t.tiv)/((${hiveconf:mymax}-${ hiveconf:mymin})/${ hiveconf:mybuckets})) ELSE floor((whatever)/((${hiveconf:mymax}-

${hiveconf:mymin})/${hiveconf:mybuckets})+1) END ELSE(${hiveconf:mybuckets})+1 END AS whateverlabel FROM(whatever table or sql)

question Width_Bucket function is not support in ESRI Spatial Framework for Hadoop. What are the alternatives fro this function? in Archives of Support Questions (Read Only)

Width_Bucket function is not support in ESRI Spatial Framework for Hadoop. What are the alternatives fro this function?

Re: Width_Bucket function is not support in ESRI Spatial Framework for Hadoop. What are the alternatives fro this function?