{
    "info": {
        "author": "Swathi Iyer",
        "author_email": "swathii@stanford.edu",
        "bugtrack_url": null,
        "classifiers": [],
        "description": "\n## Introduction\nThis API will help you optimize your sql queries for better performance.\n\n\n## How to use\nCreate an optimizer object specific to a single (database, schema) pair\ne.g. `optimizer = get_optimizer(\"presto\", schema)`\n\nGet optimization hints using `optimize_query(query)`\ne.g. `presto_op.optimize_query(query)`\n\nInitial Optimization Checks\n  * Using approximate algorithms (`approx_distinct()` instead of `COUNT(DISTINCT ...)`)\n  * Selecting the columns the user wants explicitly, rather than using `(SELECT *)`\n  * Filtering on partitioned columns\n  * Try to extract nested subqueries using a WITH clause.\n  * Suggest filtering on most effective columns, by parquet-file ordering\n  * Eliminate filtering overhead for partitioned columns\n\nOther Stuff\n  * Replace UNION with UNION ALL if duplicates do not need to be removed\n  * Aggregate a series of LIKE clauses into one regexp_like expression\n  * Push down a complex join condition into a sub query\n  * Specify GROUP BY targets with numbers for expressions\n\n### Testing\nTo run unit tests, run `py.test` (or `py.test -s` to see stdout) in the tests directory.\n",
        "description_content_type": "",
        "docs_url": null,
        "download_url": "",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "https://github.com/mozilla/user-query-optimizer",
        "keywords": "",
        "license": "LICENSE.txt",
        "maintainer": "",
        "maintainer_email": "",
        "name": "user-query-optimizer",
        "package_url": "https://pypi.org/project/user-query-optimizer/",
        "platform": "",
        "project_url": "https://pypi.org/project/user-query-optimizer/",
        "project_urls": {
            "Homepage": "https://github.com/mozilla/user-query-optimizer"
        },
        "release_url": "https://pypi.org/project/user-query-optimizer/0.1.6/",
        "requires_dist": null,
        "requires_python": "",
        "summary": "SQL query optimization hints",
        "version": "0.1.6"
    },
    "last_serial": 4249948,
    "releases": {
        "0.1.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "f830c31bfc21507536c7b288a0f9493c",
                    "sha256": "692ccf907dc2df9733da0975770ffdd528ec73e7b7c0c5ede82608b973830ab6"
                },
                "downloads": -1,
                "filename": "user-query-optimizer-0.1.0.tar.gz",
                "has_sig": false,
                "md5_digest": "f830c31bfc21507536c7b288a0f9493c",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 10907,
                "upload_time": "2018-08-22T22:10:52",
                "url": "https://files.pythonhosted.org/packages/e3/8a/3344baa4a1bf2eda66ee5fc932837a66a9e1a39c27c1588f8f5ef3167c99/user-query-optimizer-0.1.0.tar.gz"
            }
        ],
        "0.1.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "3fbabf82cf53dd870eda67131f1f1a55",
                    "sha256": "00fb66e99a7b5f0f48f1a8ce1fed4bafd145ebbe9358fa9b834a6807c44e8861"
                },
                "downloads": -1,
                "filename": "user-query-optimizer-0.1.1.tar.gz",
                "has_sig": false,
                "md5_digest": "3fbabf82cf53dd870eda67131f1f1a55",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 12216,
                "upload_time": "2018-08-24T22:51:40",
                "url": "https://files.pythonhosted.org/packages/22/73/c5d81d12ebf241f5a1ddb76bf181efdf686a71355266db212188913374e8/user-query-optimizer-0.1.1.tar.gz"
            }
        ],
        "0.1.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "6516af5e9e3179a9afdaa86cf2d3209d",
                    "sha256": "c2977f26f96c7cc3dd6afd4eb8e9a44e0a1c3fcbe88b6dd48f61abc1366ae2ed"
                },
                "downloads": -1,
                "filename": "user-query-optimizer-0.1.2.tar.gz",
                "has_sig": false,
                "md5_digest": "6516af5e9e3179a9afdaa86cf2d3209d",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 12245,
                "upload_time": "2018-08-26T01:49:14",
                "url": "https://files.pythonhosted.org/packages/aa/23/3692c111241897ca98b4f8075fa68746163f91dbfeb7bc904f9fc2f72673/user-query-optimizer-0.1.2.tar.gz"
            }
        ],
        "0.1.3": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "bc28d0959ad1b30bd43525c2b32db9e5",
                    "sha256": "6edf745ba98b12d75d588dd5dccee15a89b285ba816bf2645050f3a3aface87a"
                },
                "downloads": -1,
                "filename": "user-query-optimizer-0.1.3.tar.gz",
                "has_sig": false,
                "md5_digest": "bc28d0959ad1b30bd43525c2b32db9e5",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 12743,
                "upload_time": "2018-09-07T03:54:41",
                "url": "https://files.pythonhosted.org/packages/fc/dc/088a2a7d6bb81d1a573d3947be9da3fc739999e08db4ff950caeabe1b2e9/user-query-optimizer-0.1.3.tar.gz"
            }
        ],
        "0.1.4": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "cf753441bf0ff0c83b555fcb125ed26a",
                    "sha256": "5871bd1a24e2041686d21ca92eb126a33f2bac736069ea3f824d6d8f50ee8b09"
                },
                "downloads": -1,
                "filename": "user-query-optimizer-0.1.4.tar.gz",
                "has_sig": false,
                "md5_digest": "cf753441bf0ff0c83b555fcb125ed26a",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 12691,
                "upload_time": "2018-09-07T20:16:53",
                "url": "https://files.pythonhosted.org/packages/cc/db/a7d40148d91fb89dc306ab7d2efa84b7a9e7b3a0aa52ec5460678a56ea08/user-query-optimizer-0.1.4.tar.gz"
            }
        ],
        "0.1.5": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "eaaf3acf0613d9eef0943ec5c5ab5d7f",
                    "sha256": "225b8d3fec68ddf741be8e053afa16df28b5ea079999fb1acd87350259067356"
                },
                "downloads": -1,
                "filename": "user-query-optimizer-0.1.5.tar.gz",
                "has_sig": false,
                "md5_digest": "eaaf3acf0613d9eef0943ec5c5ab5d7f",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 12704,
                "upload_time": "2018-09-07T20:23:09",
                "url": "https://files.pythonhosted.org/packages/24/ab/eae2067c4cc6c3de0e2a3c6759470082f01cad18f2e705f13dde5a8d68b4/user-query-optimizer-0.1.5.tar.gz"
            }
        ],
        "0.1.6": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "82dae43e9fc9879303279683b59ed97d",
                    "sha256": "6fd7f53a9aebaf2004b3955526aa6a39cb07e278e3ba8ba5f45fd06ad984d637"
                },
                "downloads": -1,
                "filename": "user-query-optimizer-0.1.6.tar.gz",
                "has_sig": false,
                "md5_digest": "82dae43e9fc9879303279683b59ed97d",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 12757,
                "upload_time": "2018-09-07T20:30:39",
                "url": "https://files.pythonhosted.org/packages/cb/04/61a5c96599c776b4725af4681583429f1640e0bbb2b000bbb917f6a0083c/user-query-optimizer-0.1.6.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "82dae43e9fc9879303279683b59ed97d",
                "sha256": "6fd7f53a9aebaf2004b3955526aa6a39cb07e278e3ba8ba5f45fd06ad984d637"
            },
            "downloads": -1,
            "filename": "user-query-optimizer-0.1.6.tar.gz",
            "has_sig": false,
            "md5_digest": "82dae43e9fc9879303279683b59ed97d",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 12757,
            "upload_time": "2018-09-07T20:30:39",
            "url": "https://files.pythonhosted.org/packages/cb/04/61a5c96599c776b4725af4681583429f1640e0bbb2b000bbb917f6a0083c/user-query-optimizer-0.1.6.tar.gz"
        }
    ]
}