Amazon AthenaのCREATE TABLE AS (CTAS) を検証してみる / Hello, Cloud

    Posted on 2018/11/11

    ピースが揃ってきたのでは

    昨今AWSを使ってサーバーレスな分析のインフラを組むときはKinesis Data Firehoseに適当にデータを突っ込めば適当な粒度で.parquet.snappyに落とし込んでくれて後はそれをAthenaで読めるようにすれば良い感じにクエリできます。

    しかし出力先に柔軟性がなくてレコードに含まれる情報から日別にパーティションを切ったりするのが難しく今ひとつ惜しい感じでありました。ところが先月AthenaにCTASが入ってクエリからテーブルを作れるようになったので適当に集めたデータに対してAthenaでパーティションを切り直せるか試してみました。

    対象のデータ

    %sh
    aws s3 ls --human-readable --recursive s3://hatena-bookmark-analysis/data/user_bookmarks | grep sh19910711
    2018-11-04 10:41:54    1.8 MiB data/user_bookmarks/id=sh19910711/user_bookmarks.parquet.snappy
    

    はてブした記事のURL、タイトル、コメント、ブックマーク数などをparquetに変換してsnappyで圧縮したもの(全期間分)。

    Glueの準備

    %sh
    cat << EOF > /tmp/database.yml
    Resources:
        Database:
            Type: AWS::Glue::Database
            Properties:
                DatabaseInput: 
                    Name: hatebu
                CatalogId: !Ref AWS::AccountId
    
        UserBookmarks:
            Type: AWS::Glue::Table
            Properties:
                CatalogId: !Ref AWS::AccountId
                DatabaseName: hatebu
                TableInput:
                    Name: user_bookmarks
                    TableType: EXTERNAL_TABLE
                    Parameters: {
                        "parquet.compress": "SNAPPY"
                    }
                    StorageDescriptor:
                        Location: 's3://hatena-bookmark-analysis/data/user_bookmarks'
                        InputFormat: org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat
                        OutputFormat: org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat
                        SerdeInfo:
                            SerializationLibrary: org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe
                            Parameters: {
                                "serialization.format": "1"
                            }
                        Columns:
                        - Name: title
                          Type: string
                        - Name: comment
                          Type: string
                        - Name: url
                          Type: string
                        - Name: user_num
                          Type: bigint
                        - Name: time
                          Type: timestamp
                    PartitionKeys:
                    - Name: id
                      Type: string
    EOF
    
    aws cloudformation deploy --stack-name hatena-bookmark-analysis-database --template-file /tmp/database.yml
    Waiting for changeset to be created..
    Waiting for stack create/update to complete
    Successfully created/updated stack - hatena-bookmark-analysis-database
    

    GlueのData Catalogにテーブルを追加。TableInputのParametersがCREATE TABLEするときの tblproperties に対応していて、SerdeInfoのParametersが serdeproperties に対応している(最初どれがどれか分からなかった)。

    パーティションの読み込み

    %athena
    msck repair table hatebu.user_bookmarks

    圧縮形式やSerdeの設定に注意してください。

    クエリしてみる

    %athena
    select
        date,
        count(1)
    from
        (select
            date(time) as date
        from
            hatebu.user_bookmarks
        where
            id = 'sh19910711'
        )
    where
        year(date) between 2016 and 2018
    group by
        date
    order by
        date

    よさそう👌

    CTASでデータ整形

    %athena
    create table hatebu.daily_bookmarks
    with (
        format='PARQUET',
        external_location='s3://hatena-bookmark-analysis/data/daily_bookmarks/',
        partitioned_by = ARRAY['date']
    )
    as
    select
        *
    from
        (select
            *,
            date(time) as date
        from
            hatebu.user_bookmarks
        )
    where
        date between date('2018-01-01') and date('2018-03-31')
    Query executed successfully. Affected rows : -1

    本題のCTASクエリです。年月日だと一度に追加できるパーティションの上限(100件)に引っかかります(HIVE_TOO_MANY_OPEN_PARTITIONS)。微妙に不便だけど増える見込みはあるのだろうか。

    年ごとでやり直す

    %athena
    create table hatebu.yearly_bookmarks
    with (
        format='PARQUET',
        parquet_compression = 'SNAPPY',
        external_location='s3://hatena-bookmark-analysis/data/yearly_bookmarks/',
        partitioned_by = ARRAY['y']
    )
    as
    (select
        *,
        year(time) as y
    from
        hatebu.user_bookmarks
    )
    Query executed successfully. Affected rows : -1

    %sh
    aws s3 ls --human-readable --recursive s3://hatena-bookmark-analysis/data/yearly_bookmarks/
    2018-11-11 08:04:08   76.9 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_04e002f3-da0c-49d2-8832-5836d4a5bfc5
    2018-11-11 08:04:08   52.1 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_0a97f437-a7d2-4b2b-9a6e-bc3fdde5191e
    2018-11-11 08:04:06    1.4 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_1719ff27-3786-43ca-901e-a9e3400b7f70
    2018-11-11 08:04:06   48.0 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_18126607-2181-4b85-9354-058680b3a9cd
    2018-11-11 08:04:08  352.0 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_19e6c8c9-ce30-479b-94b2-b833131b7a37
    2018-11-11 08:04:08   94.0 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_36cff8dd-1dee-49d2-9d77-1f5c39fbba03
    2018-11-11 08:04:08   17.1 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_383f1a76-6464-4c3a-a3a9-eddec70b3327
    2018-11-11 08:04:07   35.6 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_3bd52ae3-68d3-47e5-91a8-a7f8b03dd07f
    2018-11-11 08:04:08  154.2 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_3ee2df52-2862-4771-8362-d24c081ec664
    2018-11-11 08:04:07   53.7 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_42af4591-b270-497c-8b77-8796d9695490
    2018-11-11 08:04:08  218.4 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_44663a5f-5dc2-43b5-b983-2234932a7f04
    2018-11-11 08:04:09  104.8 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_5247e3fe-9c6f-438d-aff4-eaca9e599fd3
    2018-11-11 08:04:08   20.6 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_59b20c63-4370-4c31-b425-768a5626e97a
    2018-11-11 08:04:08    6.1 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_70e5fd40-251e-4f3c-9104-c2adaae299ed
    2018-11-11 08:04:08    6.3 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_7dd55261-e670-4ee2-9c4d-f687ac672a03
    2018-11-11 08:04:08   81.6 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_83f53b27-732c-4246-9fa3-4159cd356526
    2018-11-11 08:04:08  141.7 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_9c531b68-fabe-47ac-a2eb-67efc54ad05a
    2018-11-11 08:04:07   45.6 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_a33d0f5c-c3a9-4513-b044-16e4d3fc0cfd
    2018-11-11 08:04:08  265.5 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_b0d04b04-0644-4aca-9a18-246997041290
    2018-11-11 08:04:09  219.6 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_b81f02f1-ae12-4f22-8f52-f57a3f13fa33
    2018-11-11 08:04:08   79.2 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_c6da8f22-0b22-4bc3-9c22-05e036f32e99
    2018-11-11 08:04:08  107.4 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_d56683b2-cd85-4c28-b25f-9807f86d6c4c
    2018-11-11 08:04:08   77.9 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_f237cd5a-265a-4972-98de-627405d56c3c
    2018-11-11 08:04:08  329.4 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_f25de931-0201-4c44-bf98-ba90e0c701d7
    2018-11-11 08:04:08   21.2 KiB data/yearly_bookmarks/y=2005/20181111_080400_00010_r6wvg_f5a223fd-01c8-43a5-bb0c-b2f8790d70cb
    2018-11-11 08:04:06  332.1 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_02fc5810-4200-4163-b311-6a12196e0b2a
    2018-11-11 08:04:07   98.8 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_13636537-b974-423f-831c-26c5ede8174c
    2018-11-11 08:04:08   24.2 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_21ada576-8b09-4ba6-98a0-b0edd995548f
    2018-11-11 08:04:08  247.4 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_42036ebe-aa29-4a2b-88c9-60b62cfed54d
    2018-11-11 08:04:08  562.1 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_51998063-9217-4e28-a86b-015f7bc0f01e
    2018-11-11 08:04:08  228.1 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_6b84a1d6-e915-4e02-a64e-c461509d1f4a
    2018-11-11 08:04:07  661.5 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_702c3e90-8104-410d-adb7-81f7b1d7d8da
    2018-11-11 08:04:08  752.8 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_77efc71f-1400-4ff1-a82e-57209a08f80e
    2018-11-11 08:04:07  261.8 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_7dd788c8-1111-4c50-8ca9-850dbd497371
    2018-11-11 08:04:08  697.8 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_7deaf09e-e367-4cd3-b732-8c5702140762
    2018-11-11 08:04:08  489.6 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_829f8885-6cd6-4319-b1f8-702930c8d6ef
    2018-11-11 08:04:08  405.3 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_86a9d440-24ac-410d-a6ee-fed4869ee9b8
    2018-11-11 08:04:08  376.7 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_897926c2-de2d-4a8b-a8d4-e9297cfa7a94
    2018-11-11 08:04:08  368.2 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_9494655b-574c-4197-aaf4-5e8f5e65292d
    2018-11-11 08:04:07   39.2 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_9795385a-6752-4f01-959e-9ae04e04cb4b
    2018-11-11 08:04:08  252.6 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_a4ad1d6f-3e96-42d0-b232-755c11ce50c4
    2018-11-11 08:04:07  338.3 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_a7d3a751-af52-4edd-94dc-d78850db7fa9
    2018-11-11 08:04:08  520.8 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_a8f69ed1-4fb0-4995-9c40-b1f47d9d356f
    2018-11-11 08:04:08  342.8 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_b06623f3-6967-4b72-bade-cbdff12eb9b2
    2018-11-11 08:04:08  214.1 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_b22536bb-b33d-4a8a-9275-452bb544c6d9
    2018-11-11 08:04:06   51.6 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_b3ac0a0a-8534-4e48-9041-31c849528347
    2018-11-11 08:04:07  266.1 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_b76dd605-5ccd-445b-bcba-6ae0abfe9ffa
    2018-11-11 08:04:10  240.8 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_bec02128-5783-4d50-be5c-88c342d74000
    2018-11-11 08:04:08  307.1 KiB data/yearly_bookmarks/y=2006/20181111_080400_00010_r6wvg_c4ebb0a9-346d-40ed-8949-44cb8bdc66d1
    2018-11-11 08:04:08  546.3 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_02827f6d-8f2f-45a9-9f76-bb6c2fe0aa2b
    2018-11-11 08:04:07  526.0 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_09e5ca4e-05ed-4c87-9505-d4884022d8f2
    2018-11-11 08:04:07  533.5 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_0f104c5c-ca56-442b-adf2-16822a75fa1e
    2018-11-11 08:04:08  338.4 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_1071845d-b422-4bc8-8d55-0fd8a13a7697
    2018-11-11 08:04:07  734.1 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_27d44a8f-7b86-47d0-a6c9-1e054d7d31a3
    2018-11-11 08:04:08  801.8 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_2a73c365-d597-4e80-b8bc-168b31614080
    2018-11-11 08:04:08  737.1 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_38cfd901-3d74-4398-887f-aa485ae8be0b
    2018-11-11 08:04:09  427.0 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_38f43fea-8c25-4b90-8fb2-e1af5e5a9a7c
    2018-11-11 08:04:08  697.4 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_3bb7082c-f5ff-4dd6-afed-3f47471485b0
    2018-11-11 08:04:08  824.9 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_47767d52-816d-456c-8530-6aa490eaf17e
    2018-11-11 08:04:06  548.7 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_4ec42972-3727-49a2-bbc1-e5428aa15663
    2018-11-11 08:04:08  342.7 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_5189b3ee-6f31-483a-a797-08c534393144
    2018-11-11 08:04:08    1.1 MiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_5207a353-4e29-4456-b132-111a81fbdab4
    2018-11-11 08:04:08  586.1 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_69eebd76-3db9-4cbb-a9b5-19570b03ccac
    2018-11-11 08:04:09  298.4 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_6fdbdae5-60a2-4691-ad15-e42d2e308117
    2018-11-11 08:04:08  459.4 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_8b4f74a2-0f31-45c1-a6ee-3d88d9c8df9e
    2018-11-11 08:04:07  585.9 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_990d7f69-fdb1-4b47-b832-3b0ca7cce505
    2018-11-11 08:04:07  211.9 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_9960dfb6-eb0d-4299-baef-e07fce000a50
    2018-11-11 08:04:07  191.4 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_9dd60268-49e5-403b-951b-8a0b21409cbc
    2018-11-11 08:04:07  394.1 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_a6592fe0-6d57-4c7a-9fae-060b00f91b10
    2018-11-11 08:04:08  686.9 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_a70660e7-ebd7-478c-9255-6b7c28e9b2b9
    2018-11-11 08:04:08  485.3 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_b4c0623a-728a-4729-8752-687154b32372
    2018-11-11 08:04:07  930.5 KiB data/yearly_bookmarks/y=2007/20181111_080400_00010_r6wvg_c1289a96-7933-4700-b202-0e24967b533d
    2018-11-11 08:04:08    1.5 MiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_1534b6f5-0928-4799-8628-00405bae4d8f
    2018-11-11 08:04:08  857.4 KiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_161eb02c-11c9-4e8f-b7b6-de342509b826
    2018-11-11 08:04:08  826.1 KiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_173bd548-efb0-4456-bcc6-1654a37a5d2a
    2018-11-11 08:04:07    1.0 MiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_187feb41-3f2c-426c-ae2d-194b63d38058
    2018-11-11 08:04:06    1.4 MiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_3fe2348c-8df5-42a9-b49c-82c7eae58c13
    2018-11-11 08:04:07    1.2 MiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_574a807a-fd52-4916-a1bf-a875e03dfab5
    2018-11-11 08:04:08    1.8 MiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_64a6808b-7c2d-4151-b566-ab428c7aa277
    2018-11-11 08:04:08  724.8 KiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_7957510a-d534-4abf-ac48-e551b2d4f1db
    2018-11-11 08:04:07  695.9 KiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_8b8e339d-76c9-4313-bb4d-cc59923b338b
    2018-11-11 08:04:07  111.3 KiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_8b98e8bc-4b64-44ac-9f39-dfa9f4b6dbff
    2018-11-11 08:04:08  757.0 KiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_8e7afc10-d70e-4118-9212-74904ef185d6
    2018-11-11 08:04:08  301.6 KiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_bab9cd36-02fc-44b6-86ec-aece10325649
    2018-11-11 08:04:07  729.5 KiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_bc9bc343-1280-44e4-9ccc-06bb77025c68
    2018-11-11 08:04:08  860.8 KiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_c111d187-edb5-4b97-94ae-68a120bbcb02
    2018-11-11 08:04:07  662.2 KiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_c29258be-f91f-4ff4-a58e-be3624e91faf
    2018-11-11 08:04:08    1.0 MiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_cb08b7b9-6009-4374-96a6-9d275b753223
    2018-11-11 08:04:06    1.0 MiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_d5b8e655-9fdc-4c21-9f4f-5dbec326a58f
    2018-11-11 08:04:06    1.5 MiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_e47f96c1-0d4b-47f8-9f58-598f785c5439
    2018-11-11 08:04:07   20.3 KiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_e55fbe56-1b3f-48ee-a48b-6f3853565d51
    2018-11-11 08:04:09  773.6 KiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_ec297b83-b42c-4266-87c9-8600a1c75609
    2018-11-11 08:04:07 1002.3 KiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_ee73a7c7-6f97-49e7-9dfd-f4b64cc3b6f8
    2018-11-11 08:04:08    1.4 MiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_f1a60840-4c48-47ca-a546-778ddc585f12
    2018-11-11 08:04:08    1.0 MiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_f775195a-db51-4def-a170-75dd9d45cd60
    2018-11-11 08:04:07  760.7 KiB data/yearly_bookmarks/y=2008/20181111_080400_00010_r6wvg_f7f6e9c3-49dc-4b81-8e12-3fe7af00e405
    2018-11-11 08:04:08    1.8 MiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_0ba50b0b-2513-4850-a568-dd1184c115ac
    2018-11-11 08:04:07    1.3 MiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_0ba72447-528e-4b02-bb71-6d026114efd1
    2018-11-11 08:04:08    1.2 MiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_206389ec-db59-4c1b-bc70-2cba81e2bbe0
    2018-11-11 08:04:07    1.0 MiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_26b8c05a-1794-4296-92b6-d30afafafdbd
    2018-11-11 08:04:08    2.0 MiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_47375585-8701-4130-bd3d-e13f194087dc
    2018-11-11 08:04:07  348.4 KiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_537b2a63-12ee-44ea-86b7-e264039426bb
    2018-11-11 08:04:07    2.0 MiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_5991530f-2444-4986-aced-fc8d7f3eaa2f
    2018-11-11 08:04:07    1.6 MiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_6df9bbb7-5412-4c94-a20b-ea7c9e08ed31
    2018-11-11 08:04:06    1.2 MiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_734fdd1e-65b2-4e6e-a73d-cbb07f4358e5
    2018-11-11 08:04:07    1.2 MiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_793c2b89-f60f-40a7-9472-879236f4a2cc
    2018-11-11 08:04:06    1.8 MiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_81508157-2e68-45ed-b02f-75d74220df95
    2018-11-11 08:04:07    1.1 MiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_8dc57663-d45f-49bb-80a8-f348d24773ed
    2018-11-11 08:04:08  662.5 KiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_9051b0c7-1106-4186-a3a4-77f21559d04c
    2018-11-11 08:04:07    1.4 MiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_9253b98b-ab60-40e3-a461-c329535c2fb4
    2018-11-11 08:04:07    1.5 MiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_9fa869ab-3340-4bf6-8425-01e90aee02fe
    2018-11-11 08:04:07   17.7 KiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_a188eee2-1ee6-4fcd-842c-3ae5053ffda9
    2018-11-11 08:04:08    1.2 MiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_a8d655c1-4271-4770-82b1-04cfe55b0d1a
    2018-11-11 08:04:08    1.1 MiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_b9a081d9-9338-4e8b-a342-2dc60691683b
    2018-11-11 08:04:08    1.3 MiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_cdca8e97-8586-4cd4-849f-997dfbcc2819
    2018-11-11 08:04:07    1.0 MiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_d409ed01-bea2-4469-b363-717df4275003
    2018-11-11 08:04:07    1.6 MiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_d6bf0d45-7d98-4242-9c68-82e5345dfe5a
    2018-11-11 08:04:07  970.1 KiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_dfe4b17c-a4bf-4076-8eaa-3640551ed4ff
    2018-11-11 08:04:06    1.8 MiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_e69e9358-fd10-4cd4-8389-fc704930fef6
    2018-11-11 08:04:07    1.2 MiB data/yearly_bookmarks/y=2009/20181111_080400_00010_r6wvg_eca7f106-a235-4e93-816b-b138855c3da9
    2018-11-11 08:04:07    1.8 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_00cd1a17-6b73-40be-86f0-c53f9d6749b6
    2018-11-11 08:04:08    1.9 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_109c3d88-cced-4350-962d-b0772acef0c4
    2018-11-11 08:04:07    1.3 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_1a67f153-a492-45ec-8736-6c373b86f05b
    2018-11-11 08:04:07    1.7 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_1df84264-64ed-4188-817d-66e7171a7cca
    2018-11-11 08:04:08    1.6 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_232c7e12-f836-493d-8246-c04dbad190a4
    2018-11-11 08:04:07    1.5 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_27541470-827f-445f-827a-6ff7abcd158f
    2018-11-11 08:04:07    1.6 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_4b14b22e-2541-4281-8056-3b08160f91e2
    2018-11-11 08:04:06    2.2 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_500c870d-48ce-42ec-a696-9c60454c7522
    2018-11-11 08:04:07    1.4 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_541520b5-5f38-4bb6-8a73-b3b638fc7356
    2018-11-11 08:04:07    1.8 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_681b1aac-a499-4720-a89e-045d7238bc0e
    2018-11-11 08:04:08    1.4 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_688bbcb2-725c-42f0-bdf3-695477201acb
    2018-11-11 08:04:07    1.8 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_86c3d1a7-751c-4138-a9ac-09dcc280f7d4
    2018-11-11 08:04:08    1.2 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_891b2acf-cfc5-4ab0-814e-86a5e961ef06
    2018-11-11 08:04:08    1.8 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_9335de7d-ddd2-4557-99dd-07503307f981
    2018-11-11 08:04:08    2.3 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_96b63189-513c-4f49-9b7a-476b4d86aabb
    2018-11-11 08:04:07    2.3 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_9b9ff1c5-10a0-4cf1-8e1d-4c10c425d2e4
    2018-11-11 08:04:08    1.8 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_9c1e85ef-5a12-4b39-ba73-5c1c104d6a43
    2018-11-11 08:04:07  113.8 KiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_9db0ddfe-f160-4ffa-ad60-8ebe29d0ee5c
    2018-11-11 08:04:08    1.9 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_ad78b837-eaf3-4139-8359-d4cffa96b068
    2018-11-11 08:04:08    1.6 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_b3ed9900-4f2a-4081-bc09-b106a0d42bc3
    2018-11-11 08:04:07    1.6 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_cfcbdec4-64ef-46ef-82ef-178c52934a5b
    2018-11-11 08:04:07    2.8 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_d294928a-bee4-458b-bac4-6f571f525b95
    2018-11-11 08:04:07    1.9 MiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_e97a44ec-e49c-46c6-9541-12ca8b86b22c
    2018-11-11 08:04:07  403.1 KiB data/yearly_bookmarks/y=2010/20181111_080400_00010_r6wvg_fe57ab1a-fc82-4611-b2e8-9ea68564de14
    2018-11-11 08:04:06  496.5 KiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_0ee74598-f61c-4adb-880c-57128ad00314
    2018-11-11 08:04:07    2.7 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_222ab9db-6d80-49e3-9be5-efca97fb35fd
    2018-11-11 08:04:08    2.3 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_229df017-e768-4662-b078-30a217849a2f
    2018-11-11 08:04:08    1.9 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_238ca4c3-1166-4e1c-9091-a4cf5b0bb12d
    2018-11-11 08:04:08    2.0 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_2443b78a-67a3-49d6-91b6-3f3ec8d32129
    2018-11-11 08:04:07    2.8 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_2695471a-146a-432e-b776-e036c2d9e112
    2018-11-11 08:04:08    2.3 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_2ead8e25-b93c-4945-82a2-7e25b5a7c428
    2018-11-11 08:04:07    1.7 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_3251c3a5-937e-4e38-8dc4-a190944db4f2
    2018-11-11 08:04:07    2.3 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_5627a3cb-58ca-4b12-b6d8-8bfa63baaa13
    2018-11-11 08:04:07    1.8 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_7f5b6da1-cb49-4b25-a7cb-fc177e90035e
    2018-11-11 08:04:06    3.3 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_7f70548e-b9cd-460d-a80e-f446d9505dc5
    2018-11-11 08:04:08    2.1 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_915bf966-3cfa-45c7-ab09-e805f7dcc37c
    2018-11-11 08:04:06    1.6 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_9359137c-98af-4a5e-b8ae-3a3b97a7477e
    2018-11-11 08:04:07    3.3 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_9825e701-f6a5-4f44-baff-6c7a9a190aab
    2018-11-11 08:04:08    1.9 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_9890b071-d48a-4f7e-b0a3-2149d2036f57
    2018-11-11 08:04:06    2.4 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_9e1ab752-ab20-41e6-8271-4377c0ba1779
    2018-11-11 08:04:08    2.5 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_9e64fe6e-3746-47b6-bc36-9fed8cca0e54
    2018-11-11 08:04:06    2.4 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_a438d61f-eb2a-4e5d-aeb9-689727a25df4
    2018-11-11 08:04:07    1.6 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_cd149b6e-df31-4654-bf59-048439d9e169
    2018-11-11 08:04:07    2.1 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_d824ed46-04de-4dd3-89c0-1fb0b6613735
    2018-11-11 08:04:08    2.9 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_e68c1cbf-9276-4ba2-8e88-41f8685d885d
    2018-11-11 08:04:06    1.8 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_e8cedecd-3aeb-482c-89e6-c4f795085640
    2018-11-11 08:04:08    2.2 MiB data/yearly_bookmarks/y=2011/20181111_080400_00010_r6wvg_e9b9a9a5-87c0-47b5-b381-c390ac7eb09d
    2018-11-11 08:04:08    2.4 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_0740ef2c-9364-4383-999f-2cbacaa2a79b
    2018-11-11 08:04:07    2.4 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_07c7ae8f-f52a-476b-8912-f44b8909504f
    2018-11-11 08:04:08    3.7 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_09ae43c2-4d45-4df5-ab03-91e15cb34caa
    2018-11-11 08:04:07    2.8 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_0eb7653a-70b5-4dbd-a7f0-ff7006aa1c1f
    2018-11-11 08:04:07    1.8 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_1774061d-3288-4999-bf59-133f28979c8f
    2018-11-11 08:04:07  578.5 KiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_438f94a0-d5a9-48d4-98f8-ed1ad420df0e
    2018-11-11 08:04:07    2.7 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_457624d4-0ce4-4c4d-b557-ac86a4fc360c
    2018-11-11 08:04:09    2.8 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_46b72fc2-91cf-4b39-8299-8dba1f9ce33e
    2018-11-11 08:04:07    2.6 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_565ce5df-f555-4eac-94a1-61ab0960e85f
    2018-11-11 08:04:07    3.3 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_57ef43c9-e64f-4329-862b-5b9437fbf957
    2018-11-11 08:04:07    2.0 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_5bcd59c2-0970-420f-8178-62335caeb659
    2018-11-11 08:04:08    1.7 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_5d0c2cb6-1f1f-4757-994f-efa7b952e64b
    2018-11-11 08:04:07    3.3 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_5dcb4588-c69c-4d3f-8714-9d45a4737f42
    2018-11-11 08:04:07    2.3 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_6487b8f4-72c2-4d19-817f-097f34bdd966
    2018-11-11 08:04:07    2.8 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_6b152c79-6694-40c5-a2fd-f905b7d72f98
    2018-11-11 08:04:08    2.3 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_a3baf7b9-6cab-4976-9edd-1040b93cd7fb
    2018-11-11 08:04:07    2.9 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_a4f7b14e-b335-4875-9159-42913261cb63
    2018-11-11 08:04:07    2.0 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_c8fabc15-4925-48f2-9ab7-b3a561d1ee4b
    2018-11-11 08:04:08    3.1 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_c94429d4-c89f-47ed-b248-589befb6bb16
    2018-11-11 08:04:08    2.5 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_cc78f5af-5e81-40b5-abea-29798cbd3cdf
    2018-11-11 08:04:06    3.0 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_ddb6cc16-e04a-4c02-82f5-14c4cf7ed83f
    2018-11-11 08:04:07    2.3 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_e8c8245b-2bea-488e-a92d-703bbb3b6513
    2018-11-11 08:04:07    3.3 MiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_f4298a42-a324-4f72-b90f-acc079f6a8c4
    2018-11-11 08:04:06  117.8 KiB data/yearly_bookmarks/y=2012/20181111_080400_00010_r6wvg_fb0bd58b-2aee-48ef-9843-f3ac11eb518d
    2018-11-11 08:04:07    3.6 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_16263d4c-7e8e-4ea1-92b7-6444cc1ed602
    2018-11-11 08:04:07    3.1 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_18733a8c-62cf-4f33-8dab-d7090d0a333a
    2018-11-11 08:04:07    2.8 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_21fc5444-724d-45d2-9e45-61f8e0d5a27e
    2018-11-11 08:04:08    2.8 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_2c6b2878-933a-48e1-a19b-14d41d27d7a7
    2018-11-11 08:04:06    3.9 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_3545a4c8-b299-41ed-b932-40492aa0f66d
    2018-11-11 08:04:07    2.3 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_3725a5f3-9314-4b62-b0ed-8a8021e81639
    2018-11-11 08:04:07    3.2 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_46bd5b79-8578-4f61-b352-4ba64606b80e
    2018-11-11 08:04:07    3.6 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_516e23d7-ec72-456f-be30-35b94e8af915
    2018-11-11 08:04:07    3.6 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_5b06778a-76d5-4054-b970-c62b4c436298
    2018-11-11 08:04:06    4.2 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_5d6b2dc9-2321-4a3f-abf2-9c2fc240ce98
    2018-11-11 08:04:08    2.2 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_70b675de-9a3b-4e1e-95f3-46104a6594fe
    2018-11-11 08:04:08    3.0 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_92b8b15c-1042-480c-8167-690f333b8980
    2018-11-11 08:04:07    2.9 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_96905278-5222-4bf8-8384-f34a0ea334be
    2018-11-11 08:04:07    3.8 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_98335f8d-3e78-4c7a-adcd-257372d40750
    2018-11-11 08:04:07    2.6 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_a04a1fcf-1d41-497a-9007-92fe5ac3dec3
    2018-11-11 08:04:08    2.0 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_b026f146-feac-4261-b22c-f3cfe5cd1fb0
    2018-11-11 08:04:07    3.2 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_b8d5939a-f936-43f2-99d2-42cfd503c314
    2018-11-11 08:04:07    3.2 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_b980c141-d675-4a7a-afe2-5539b2e2c888
    2018-11-11 08:04:08    2.6 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_bcb9e489-f1db-423c-99c2-c7118404dbbd
    2018-11-11 08:04:07  828.8 KiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_bd4d1cc1-d2b3-4fee-924a-f66dff072cfe
    2018-11-11 08:04:07    3.8 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_d6efecc8-2766-4bb4-b6c9-d1a6fdabb529
    2018-11-11 08:04:07    3.1 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_d900b0bd-cdef-4060-901c-d809c247c634
    2018-11-11 08:04:07    3.3 MiB data/yearly_bookmarks/y=2013/20181111_080400_00010_r6wvg_fd831dd3-2d70-4262-a506-8703de5bbdca
    2018-11-11 08:04:07    4.1 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_352f7ecd-0c57-4718-a25b-250f502f391d
    2018-11-11 08:04:08    3.1 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_428e40c9-de87-4a1d-96a5-408c5d0469e6
    2018-11-11 08:04:07    2.9 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_49222d52-c156-4f09-8255-b6216510a7ee
    2018-11-11 08:04:08    2.7 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_5225ff50-406c-4198-a230-da9e87fecd9f
    2018-11-11 08:04:07    3.5 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_5355d1b9-5183-46ae-9a09-b2586a54eebe
    2018-11-11 08:04:08    3.6 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_576abcc1-121e-4966-b33a-521efd12c98b
    2018-11-11 08:04:07    3.7 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_67711d06-8271-4806-b73b-b000be0989be
    2018-11-11 08:04:08    2.7 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_6d0f3ecc-b75a-4d53-b888-5f2146a5fc6e
    2018-11-11 08:04:07    3.0 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_7704d68c-ea23-4d4e-a636-ffd0f1d851d1
    2018-11-11 08:04:07  832.1 KiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_90a90cb1-d384-4a5c-9a30-c802aa183788
    2018-11-11 08:04:07    3.3 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_9b092d3e-7341-41d2-aad1-06d03b898dae
    2018-11-11 08:04:07    3.8 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_a7f4b6f5-e97b-406d-9382-522e8fd88900
    2018-11-11 08:04:07    2.5 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_c75d6ba1-87c9-4ca3-a70e-1879e5c1c0dc
    2018-11-11 08:04:08    3.3 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_cdd0d958-ab37-42d4-a854-079bc853aef4
    2018-11-11 08:04:07    1.9 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_d3bdebf1-c02f-490f-b7a4-b891ba49b461
    2018-11-11 08:04:07    3.2 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_d4c1f2cc-5344-473b-ae88-a745b1ee7cbc
    2018-11-11 08:04:07    4.2 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_d6bbdcf2-9b47-460c-9550-ce80eb562390
    2018-11-11 08:04:08    2.7 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_da48b17c-3152-4f70-b62d-c6d26d21f5c6
    2018-11-11 08:04:07    3.4 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_e856b5da-82fe-4de4-b122-10982c18e4d9
    2018-11-11 08:04:06    3.5 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_f09ed12d-dcd8-4ff3-b079-a7847d1f96fb
    2018-11-11 08:04:08    2.2 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_f5cda716-b41e-4cf8-9ca8-b650b9d87990
    2018-11-11 08:04:07    2.3 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_fd14a6e0-4954-47f6-8fc1-cbb37f17938c
    2018-11-11 08:04:08    3.4 MiB data/yearly_bookmarks/y=2014/20181111_080400_00010_r6wvg_fd3a0b43-e488-4485-bb14-f37cb4a44bf9
    2018-11-11 08:04:07    3.0 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_018c6d80-3931-479e-abd3-baca95880eb9
    2018-11-11 08:04:08    2.7 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_0336aea7-48c7-4b07-8d68-67001ddf8b08
    2018-11-11 08:04:06    2.5 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_05b4194b-6848-4c86-b907-5ef860751ff0
    2018-11-11 08:04:07    3.3 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_0984ddfa-0727-49d0-a4c0-f7e3350add63
    2018-11-11 08:04:07    2.8 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_11d70bb8-ba9c-4fdd-a55d-ffd2c87eeb3b
    2018-11-11 08:04:07    4.4 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_197d262f-22c3-4b23-bc2d-ef70ad1c78de
    2018-11-11 08:04:08    3.4 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_1fdfc221-b3d3-442d-90c8-17f0e613f026
    2018-11-11 08:04:08    2.8 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_283500c9-261e-40b4-be0c-6e3b646aae9f
    2018-11-11 08:04:07    3.2 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_388acfc6-edb8-4865-b396-4de238c5fe8a
    2018-11-11 08:04:07    2.3 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_3ba30bf8-cfcb-49cd-86c1-b1b1f9ad5ca8
    2018-11-11 08:04:07    3.4 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_4301c511-caea-49a1-b659-35d0c1ac18a6
    2018-11-11 08:04:08    3.0 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_4a725315-0740-4b33-8881-ebeddec0790d
    2018-11-11 08:04:06   60.0 KiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_4c9e2d8d-9d66-4647-8e9c-7ff1dbe7f277
    2018-11-11 08:04:07    2.8 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_5307daa5-7d89-437c-b76a-40e1327a5d17
    2018-11-11 08:04:07    3.7 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_6c251481-85ab-4b02-b152-65c8a21c3b72
    2018-11-11 08:04:07    2.7 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_6d3bb0aa-efb8-4f51-bb13-04d6227641f7
    2018-11-11 08:04:07    3.6 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_6fd66b6d-629a-46ba-99f5-75f03194c88b
    2018-11-11 08:04:08    4.2 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_708c4c97-9be3-4b64-9a94-000cb5ac0e79
    2018-11-11 08:04:07    2.5 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_96e967e4-3675-49bf-be5c-79a9f94e67aa
    2018-11-11 08:04:06    2.9 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_a814d15d-044c-409d-be8c-e27565a23cd3
    2018-11-11 08:04:08    2.1 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_d7cf210c-1cc3-42d2-8e17-e5ef4a0d017b
    2018-11-11 08:04:07  591.9 KiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_dfaf750e-d8ab-472a-930f-946c0910bb27
    2018-11-11 08:04:07    2.8 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_f154e762-35e4-484a-99aa-af9d31dd3478
    2018-11-11 08:04:07    2.4 MiB data/yearly_bookmarks/y=2015/20181111_080400_00010_r6wvg_ffbab7f0-de5f-4a9c-8e30-3d7f580d2fc3
    2018-11-11 08:04:07  585.2 KiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_02c168da-dbe5-401f-9ecb-90a1f51a1bb5
    2018-11-11 08:04:08    3.2 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_0fda6db5-c235-4efa-b143-f963fd26aa0d
    2018-11-11 08:04:07    2.6 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_2586ce90-e904-421c-acf5-72579379dbb9
    2018-11-11 08:04:07    2.8 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_2d9351f2-bc77-4f4f-8477-623e9036cb42
    2018-11-11 08:04:07    2.5 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_532ab222-a620-4e30-be88-2c8b58d18603
    2018-11-11 08:04:06    3.3 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_69e13475-61fa-4a27-9b9c-c1bafa3a541b
    2018-11-11 08:04:06   64.9 KiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_7cb6dee1-6d09-49d4-a740-0b5a420793f8
    2018-11-11 08:04:07    3.2 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_816ad00b-e56c-4d1d-81d8-385b64e4fac4
    2018-11-11 08:04:07    4.0 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_85808400-6db6-4750-bbcd-4b5f817559bf
    2018-11-11 08:04:08    2.6 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_85d1b7a1-d9af-4e8d-8023-82ae373ebfdc
    2018-11-11 08:04:07    2.6 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_8be7a2cb-e872-472e-b091-93837c1044bb
    2018-11-11 08:04:07    3.9 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_8f2eaf80-1cd0-4515-91cd-3585bba549a1
    2018-11-11 08:04:07    3.1 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_9c3bef79-b3b1-41c4-b933-b07472e25606
    2018-11-11 08:04:08    2.5 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_a3317523-bbd2-45cd-a6fc-b7293f54276f
    2018-11-11 08:04:07    3.1 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_a49fefee-eb5f-407f-a2a2-aadd2d02d3aa
    2018-11-11 08:04:07    1.9 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_a9c7408b-8fa3-4fae-8941-6c6e0450703e
    2018-11-11 08:04:08    1.3 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_b0b589c8-064a-4039-b4c3-b4e26a541d61
    2018-11-11 08:04:07    2.4 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_bed10386-be28-4c87-ad8e-3c6d6401db23
    2018-11-11 08:04:07    3.1 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_c45d42ec-193c-48d1-8c94-4c7e4d9dfe77
    2018-11-11 08:04:07    3.5 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_c4e93639-5fb7-418c-9cf0-e5a60c0f4fe7
    2018-11-11 08:04:07    3.7 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_dbee165c-0aa1-419b-93df-f0f827b6a5eb
    2018-11-11 08:04:07    3.1 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_e0c93864-e064-4406-96c2-07c26e4e966d
    2018-11-11 08:04:08    2.4 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_f0864330-cb07-4489-b382-fd92005ba2d4
    2018-11-11 08:04:06    2.1 MiB data/yearly_bookmarks/y=2016/20181111_080400_00010_r6wvg_fcac1a15-e9b9-4fa5-bfc1-b9b5e6730fc2
    2018-11-11 08:04:08    3.5 MiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_1d5ab93d-d91f-4d0e-b9a0-3ece473c81db
    2018-11-11 08:04:07    2.4 MiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_1e0d6872-e8c9-4f4b-8e34-f42b54f80ba5
    2018-11-11 08:04:07  259.0 KiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_2216aae9-4b2c-4b8e-8223-93dac486e0bc
    2018-11-11 08:04:07    1.8 MiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_36d5ae63-e434-44d3-ba41-fe0f525d8ba8
    2018-11-11 08:04:06    3.0 MiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_50b98de7-7213-407b-865a-447410616ccb
    2018-11-11 08:04:07    2.4 MiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_67d650d1-df74-462f-abc3-eebe6b5a53ed
    2018-11-11 08:04:06    3.6 MiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_6b10fa27-80ac-4a7d-a982-c134d16c6d9c
    2018-11-11 08:04:07    1.9 MiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_6d98b606-04f7-477a-a6ca-7e658142ec43
    2018-11-11 08:04:07    2.1 MiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_742ed90e-a6b1-458c-a953-aeba41f330b2
    2018-11-11 08:04:07    3.4 MiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_919eeac6-d720-4aca-bf9b-4d59e67cbe3e
    2018-11-11 08:04:08    3.4 MiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_9604b0aa-1f50-40fc-96c3-ee6c16aed494
    2018-11-11 08:04:07    3.2 MiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_a4b14870-53ba-4a8e-8517-1cecf876080d
    2018-11-11 08:04:07    2.2 MiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_a74d73e9-3d32-4fa0-b19d-a5744d277c1c
    2018-11-11 08:04:07    1.3 MiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_aeba4592-f0e1-4cc2-9bab-034782fb47b3
    2018-11-11 08:04:07    2.4 MiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_af211827-2fed-4d12-a278-23c58896b94e
    2018-11-11 08:04:09    3.2 MiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_cb8d3f7c-41e4-423e-a6c2-97943c673562
    2018-11-11 08:04:07    2.9 MiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_cc0df267-3ec7-48a9-a89c-dce89151fa99
    2018-11-11 08:04:07    3.1 MiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_cf436ada-1d1e-4740-a831-31de8d019c56
    2018-11-11 08:04:08  826.2 KiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_d13ced65-339d-4181-bb5c-fd81033589a8
    2018-11-11 08:04:07    3.1 MiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_d3b9f823-5bbb-4d73-abe9-af7bd91e6b72
    2018-11-11 08:04:09    2.1 MiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_d47fedcb-049e-4a16-92b8-85c3249b61e5
    2018-11-11 08:04:08    2.9 MiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_dc17218d-4f52-48c1-af79-d8c2621980f9
    2018-11-11 08:04:07    2.0 MiB data/yearly_bookmarks/y=2017/20181111_080400_00010_r6wvg_eeeb4042-d56e-4370-9c84-aa7fd6964e66
    2018-11-11 08:04:08    1.6 MiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_0f9e57cc-64da-4d2f-ba60-853081119845
    2018-11-11 08:04:09    4.7 MiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_0f9f9edc-4a4b-43ff-a16c-b64b1c17c04c
    2018-11-11 08:04:08    3.1 MiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_15f4e737-ef59-48ab-abbf-97617672a6e1
    2018-11-11 08:04:06    5.4 MiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_26532d9c-fd73-4ccf-9fc1-8a2824ae8dba
    2018-11-11 08:04:07    1.4 MiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_32de1448-59da-4a49-bff0-c1caeba9a595
    2018-11-11 08:04:08    2.9 MiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_35b37043-e624-438d-8500-5fec32b228bd
    2018-11-11 08:04:07    3.4 MiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_3b9227e4-f3d4-4040-98c9-7844581a4bd9
    2018-11-11 08:04:08    2.4 MiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_46d3630a-261f-4915-9275-1794dce729e2
    2018-11-11 08:04:08    1.7 MiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_4ed2fada-110d-42db-bc7e-7d5645aebab1
    2018-11-11 08:04:08    2.0 MiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_5c036633-ac38-4d70-ac90-7b0d00fcb88f
    2018-11-11 08:04:09    1.6 MiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_7f5c3f22-9ac1-4dbc-bace-2f2c3986e839
    2018-11-11 08:04:08  194.7 KiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_a327aa5b-f194-4c6f-9e61-d5e557e43611
    2018-11-11 08:04:07  970.3 KiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_aa2eef35-9b50-4e79-a158-dae77df4c480
    2018-11-11 08:04:07    1.2 MiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_b2bb6f66-18d8-43d1-8865-4caf17a1c08b
    2018-11-11 08:04:07    3.8 MiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_b3172343-153b-4772-84f8-0c218fc5f861
    2018-11-11 08:04:09    1.1 MiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_bbc2ecdd-8780-442a-8634-664dba483293
    2018-11-11 08:04:09    3.6 MiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_bdc85753-fbd3-4cb0-81c9-c71699447f5c
    2018-11-11 08:04:08    1.6 MiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_be900f62-f89a-4a29-983f-66fc822b731d
    2018-11-11 08:04:07    1.1 MiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_cf90d860-d118-4e8f-a301-a17959a4dbc8
    2018-11-11 08:04:08    1.6 MiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_d0645c66-1285-48b3-8a7c-fb248b938126
    2018-11-11 08:04:07    1.8 MiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_d94607e5-052c-4395-9062-f5cc786e5221
    2018-11-11 08:04:07  833.3 KiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_e88c9072-9bad-4f9f-82aa-3e3fd8e3a142
    2018-11-11 08:04:07  166.4 KiB data/yearly_bookmarks/y=2018/20181111_080400_00010_r6wvg_f84e17d2-0516-4a2b-91c1-ab2ddf02c35c
    

    Query executed successfully. Affected rows : -1

    クエリしてみる

    %athena
    select
        date,
        count(1)
    from
        (select
            date(time) as date
        from
            hatebu.yearly_bookmarks
        where
            id = 'sh19910711'
            and y between 2016 and 2018
        )
    group by
        date
    order by
        date

    よさそう👌 上限を超えそうな期間について月別や日別にパーティションを切りたいときはちょっと頑張る必要がありそうです。