Below is the command used to run the enrichment step
./snowplow-emr-etl-runner run --config snowplow/4-storage/config/emretlrunner.yml --resolver snowplow/3-enrich/config/iglu_resolver.json --enrichments snowplow/3-enrich/config/enrichments/
Below is my config.yml file
aws:
# Credentials can be hardcoded or set in environment variables
access_key_id: "xxxxxx"
secret_access_key: "xxxxxxx"
s3:
region: us-east-1
buckets:
assets: s3://snowplow-hosted-assets # DO NOT CHANGE unless you are hosting the jarfiles etc yourself in your own bucket
jsonpath_assets: # If you have defined your own JSON Schemas, add the s3:// path to your own JSON Path files in your own bucket here
log: s3://dataobjecteventsstorage/logs
raw:
in: # This is a YAML array of one or more in buckets - you MUST use hyphens before each entry in the array, as below
- s3://dataobjecteventsstorage/ # e.g. s3://my-old-collector-bucket
processing: s3://dataobjecteventsstorage/raw/processing
archive: s3://dataobjecteventsstorage/raw/archive # e.g. s3://my-archive-bucket/raw
enriched:
good: s3://dataobjecteventsstorage/enriched/good # e.g. s3://my-out-bucket/enriched/good
bad: s3://dataobjecteventsstorage/enriched/bad # e.g. s3://my-out-bucket/enriched/bad
errors: s3://dataobjecteventsstorage/enriched/errors # Leave blank unless :continue_on_unexpected_error: set to true below
archive: s3://dataobjecteventsstorage/enriched/archive # Where to archive enriched events to, e.g. s3://my-archive-bucket/enriched
shredded:
good: s3://dataobjecteventsstorage/shredded/good # e.g. s3://my-out-bucket/shredded/good
bad: s3://dataobjecteventsstorage/shredded/bad # e.g. s3://my-out-bucket/shredded/bad
errors: s3://dataobjecteventsstorage/shredded/errors # Leave blank unless :continue_on_unexpected_error: set to true below
archive: s3://dataobjecteventsstorage/shredded/archive # Where to archive shredded events to, e.g. s3://my-archive-bucket/shredded
emr:
ami_version: 5.9.0
region: us-east-1 # Always set this
jobflow_role: EMR_EC2_DefaultRole # Created using $ aws emr create-default-roles
service_role: EMR_DefaultRole # Created using $ aws emr create-default-roles
placement: us-east-1c # Set this if not running in VPC. Leave blank otherwise
ec2_subnet_id: # Set this if running in VPC. Leave blank otherwise
ec2_key_name: Snowplowkeypair
bootstrap: [] # Set this to specify custom boostrap actions. Leave empty otherwise
software:
hbase: # Optional. To launch on cluster, provide version, "0.92.0", keep quotes. Leave empty otherwise.
lingual: # Optional. To launch on cluster, provide version, "1.1", keep quotes. Leave empty otherwise.
# Adjust your Hadoop cluster below
jobflow:
job_name: Snowplow Unilog # Give your job a name
master_instance_type: m1.medium
core_instance_count: 2
core_instance_type: m1.medium
core_instance_ebs: # Optional. Attach an EBS volume to each core instance.
volume_size: 100 # Gigabytes
volume_type: "gp2"
volume_iops: 400 # Optional. Will only be used if volume_type is "io1"
ebs_optimized: false # Optional. Will default to true
task_instance_count: 0 # Increase to use spot instances
task_instance_type: m2.medium
task_instance_bid: 0.015 # In USD. Adjust bid, or leave blank for non-spot-priced (i.e. on-demand) task instances
bootstrap_failure_tries: 3 # Number of times to attempt the job in the event of bootstrap failures
configuration:
yarn-site:
yarn.resourcemanager.am.max-attempts: "1"
spark:
maximizeResourceAllocation: "true"
additional_info: # Optional JSON string for selecting additional features
collectors:
format: thrift # For example: 'clj-tomcat' for the Clojure Collector, 'thrift' for Thrift records, 'tsv/com.amazon.aws.cloudfront/wd_access_log' for Cloudfront access logs or 'ndjson/urbanairship.connect/v1' for UrbanAirship Connect events
enrich:
versions:
spark_enrich: 1.10.0 # Version of the Spark Enrichment process
continue_on_unexpected_error: false # Set to 'true' (and set :out_errors: above) if you don't want any exceptions thrown from ETL
output_compression: NONE # Compression only supported with Redshift, set to NONE if you have Postgres targets. Allowed formats: NONE, GZIP
storage:
versions:
rdb_loader: 0.14.0
rdb_shredder: 0.13.0 # Version of the Spark Shredding process
hadoop_elasticsearch: 0.1.0 # Version of the Hadoop to Elasticsearch copying process
monitoring:
tags: {} # Name-value pairs describing this job
logging:
level: DEBUG # You can optionally switch to INFO for production
#snowplow:
#method: get
#app_id: unilog # e.g. snowplow
#collector: 172.31.38.39:8082 # e.g. d3rkrsqld9gmqf.cloudfront.net
below is the message i got in the enrich bad bucket folder
{"line":"CwBkAAAADDE3Mi4zMS4zOC4zOQoAyAAAAWAHUMapCwDSAAAABVVURi04CwDcAAAAEXNzYy0wLjkuMC1raW5lc2lzCwEsAAAAck1vemlsbGEvNS4wIChXaW5kb3dzIE5UIDEwLjA7IFdpbjY0OyB4NjQpIEFwcGxlV2ViS2l0LzUzNy4zNiAoS0hUTUwsIGxpa2UgR2Vja28pIENocm9tZS82Mi4wLjMyMDIuOTQgU2FmYXJpLzUzNy4zNgsBQAAAABgvc25vd3Bsb3duZXcvc2FtcGxlLmh0bWwLAUoAAAAADwFeCwAAAAgAAAAUSG9zdDogbG9jYWxob3N0OjgwODAAAAAWQ29ubmVjdGlvbjoga2VlcC1hbGl2ZQAAAH5Vc2VyLUFnZW50OiBNb3ppbGxhLzUuMCAoV2luZG93cyBOVCAxMC4wOyBXaW42NDsgeDY0KSBBcHBsZVdlYktpdC81MzcuMzYgKEtIVE1MLCBsaWtlIEdlY2tvKSBDaHJvbWUvNjIuMC4zMjAyLjk0IFNhZmFyaS81MzcuMzYAAAAcVXBncmFkZS1JbnNlY3VyZS1SZXF1ZXN0czogMQAAAGJBY2NlcHQ6IHRleHQvaHRtbCwgYXBwbGljYXRpb24veGh0bWwreG1sLCBhcHBsaWNhdGlvbi94bWw7cT0wLjksIGltYWdlL3dlYnAsIGltYWdlL2FwbmcsICovKjtxPTAuOAAAACJBY2NlcHQtRW5jb2Rpbmc6IGd6aXAsIGRlZmxhdGUsIGJyAAAAIEFjY2VwdC1MYW5ndWFnZTogZW4tVVMsIGVuO3E9MC45AAABNUNvb2tpZTogcnhWaXNpdG9yPTE0OTU4NjQ4Mjk2NzhJMDgzSDFNTTNVVklQUVJFSVFTTkRHNVYxRlM2MzQ0VjsgbG9naW5NZXNzYWdlPWxvZ291dDsgRjQ3RjRBMEYzMEZCN0E3NT1zYW5kZXNoLnBAdW5pbG9nY29ycC5jb207IDc1MEIyRTAzMzNBMjhDMUQ9dGVzdDEyMzQ7IEYzMEZCMzNBMj10cnVlOyBhZnRlckxvZ2luVXJsPTsgX3NwX2lkLjFmZmY9YTMzMTA5MDMtMTA5NC00Y2I4LWExNzktZTIwOWNiNDE5OGY5LjE1MDAzODY2OTIuMjYuMTUxMTg3Nzk5Ni4xNTExODYxOTYxLjFhZWM0ZTVlLTYzYjYtNGIwYy04MWNiLTYzODIzZTIyMDBlZgsBkAAAAAlsb2NhbGhvc3QLAZoAAAAkOWJjZjk5ZDYtMzliMy00NDZjLTg5NDUtZTVjNWZkYTZhM2ExC3ppAAAAQWlnbHU6Y29tLnNub3dwbG93YW5hbHl0aWNzLnNub3dwbG93L0NvbGxlY3RvclBheWxvYWQvdGhyaWZ0LzEtMC0wAA==","errors":[{"level":"error","message":"Payload with vendor snowplownew and version sample.html not supported by this version of Scala Common Enrich"}],"failure_tstamp":"2017-11-29T11:09:19.729Z"}
{"line":"CwBkAAAADDE3Mi4zMS4zOC4zOQoAyAAAAWAHUOsYCwDSAAAABVVURi04CwDcAAAAEXNzYy0wLjkuMC1raW5lc2lzCwEsAAAAck1vemlsbGEvNS4wIChXaW5kb3dzIE5UIDEwLjA7IFdpbjY0OyB4NjQpIEFwcGxlV2ViS2l0LzUzNy4zNiAoS0hUTUwsIGxpa2UgR2Vja28pIENocm9tZS82Mi4wLjMyMDIuOTQgU2FmYXJpLzUzNy4zNgsBQAAAABgvc25vd3Bsb3duZXcvc2FtcGxlLmh0bWwLAUoAAAAADwFeCwAAAAkAAAAUSG9zdDogbG9jYWxob3N0OjgwODAAAAAWQ29ubmVjdGlvbjoga2VlcC1hbGl2ZQAAABhDYWNoZS1Db250cm9sOiBtYXgtYWdlPTAAAAB+VXNlci1BZ2VudDogTW96aWxsYS81LjAgKFdpbmRvd3MgTlQgMTAuMDsgV2luNjQ7IHg2NCkgQXBwbGVXZWJLaXQvNTM3LjM2IChLSFRNTCwgbGlrZSBHZWNrbykgQ2hyb21lLzYyLjAuMzIwMi45NCBTYWZhcmkvNTM3LjM2AAAAHFVwZ3JhZGUtSW5zZWN1cmUtUmVxdWVzdHM6IDEAAABiQWNjZXB0OiB0ZXh0L2h0bWwsIGFwcGxpY2F0aW9uL3hodG1sK3htbCwgYXBwbGljYXRpb24veG1sO3E9MC45LCBpbWFnZS93ZWJwLCBpbWFnZS9hcG5nLCAqLyo7cT0wLjgAAAAiQWNjZXB0LUVuY29kaW5nOiBnemlwLCBkZWZsYXRlLCBicgAAACBBY2NlcHQtTGFuZ3VhZ2U6IGVuLVVTLCBlbjtxPTAuOQAAATVDb29raWU6IHJ4VmlzaXRvcj0xNDk1ODY0ODI5Njc4STA4M0gxTU0zVVZJUFFSRUlRU05ERzVWMUZTNjM0NFY7IGxvZ2luTWVzc2FnZT1sb2dvdXQ7IEY0N0Y0QTBGMzBGQjdBNzU9c2FuZGVzaC5wQHVuaWxvZ2NvcnAuY29tOyA3NTBCMkUwMzMzQTI4QzFEPXRlc3QxMjM0OyBGMzBGQjMzQTI9dHJ1ZTsgYWZ0ZXJMb2dpblVybD07IF9zcF9pZC4xZmZmPWEzMzEwOTAzLTEwOTQtNGNiOC1hMTc5LWUyMDljYjQxOThmOS4xNTAwMzg2NjkyLjI2LjE1MTE4Nzc5OTYuMTUxMTg2MTk2MS4xYWVjNGU1ZS02M2I2LTRiMGMtODFjYi02MzgyM2UyMjAwZWYLAZAAAAAJbG9jYWxob3N0CwGaAAAAJGVmMWYxZmM4LTcwN2UtNDE3MS05YTMyLTMwYTY2MDY2MDQ2NQt6aQAAAEFpZ2x1OmNvbS5zbm93cGxvd2FuYWx5dGljcy5zbm93cGxvdy9Db2xsZWN0b3JQYXlsb2FkL3RocmlmdC8xLTAtMAA=","errors":[{"level":"error","message":"Payload with vendor snowplownew and version sample.html not supported by this version of Scala Common Enrich"}],"failure_tstamp":"2017-11-29T11:09:24.308Z"}
Please suggest me changes need to do…