A avro schema in JSON avsc format. Build using AVRO tools jar
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
LICENSE
README.md
monzo.avsc

README.md

monzo-avro

        

A while back Monzo enabled users to exports their spend data as a .csv (https://monzo.com/blog/2016/06/13/1-5/) which enabled users to dump their data into Apache Spark to manipulate their data.

I've created this schema in order to build tables in Apache Hive over data written out in AVRO format.

use monzo;
CREATE EXTERNAL TABLE monzo_spend_apr2016may2017
            STORED AS AVRO
            LOCATION '/user/hive/warehouse/monzo.db/data/'
TBLPROPERTIES('avro.schema.url'='/user/hive/warehouse/monzo.db/schemas/monzo.avsc');

Table columns will be;

id createdate amount currency localamount localcurrency category emoji description address notes receipt