Blog

Platforms: WhereOS, Spark, Hive Class: brickhouse.hbase.SaltedBigIntUDF More functions can be added to WhereOS via Python

second(timestamp) – Returns the second component of the string/timestamp. Platforms: WhereOS, Spark, Hive Class: org.apache.spark.sql.catalyst.expressions.Second

schema_of_json(json[, options]) – Returns schema in the DDL format of JSON string. Platforms: WhereOS, Spark,

rownum() – Returns a generated row number `sprintf(`%d%04d`,sequence,taskId)` in long SELECT rownum() as rownum, xxx

Platforms: WhereOS, Spark, Hive Class: brickhouse.hbase.SaltedBigIntUDF More functions can be added to WhereOS via Python

rtrim(str) – Removes the trailing space characters from `str`. rtrim(trimStr, str) – Removes the trailing