snowpark-python icon indicating copy to clipboard operation
snowpark-python copied to clipboard

add orderBy alias of sort

Open ChuliangXiao opened this issue 3 years ago • 6 comments

Please answer these questions before submitting your pull requests. Thanks!

  1. What GitHub issue is this PR addressing? Make sure that there is an accompanying issue to your PR.

    None

  2. Fill out the following pre-review checklist:

    • [ ] I am adding a new automated test(s) to verify correctness of my new code
    • [ ] I am adding new logging messages
    • [ ] I am adding new credentials
    • [ ] I am adding a new dependency
  3. Please describe how your code solves the related issue.

    Please write a short description of how your code change solves the related issue.

ChuliangXiao avatar Jun 20 '22 15:06 ChuliangXiao

CLA Assistant Lite bot All contributors have signed the CLA ✍️ ✅

github-actions[bot] avatar Jun 20 '22 15:06 github-actions[bot]

Hey @ChuliangXiao, thanks for your suggestion and we think this would be a useful alias. Could you move this alias here, and add a simple test here? Thanks!

sfc-gh-jdu avatar Jun 21 '22 22:06 sfc-gh-jdu

@ChuliangXiao can you sign the CLA as well? You just have to copy the CLA text and paste it as a comment on this PR before we can run your tests/accept your PR

sfc-gh-kwagner avatar Jun 22 '22 01:06 sfc-gh-kwagner

Snowflake Open Source Contribution

Terms and Conditions

By accepting and agreeing to this contributor license agreement, I understand and agree that my Contribution (as defined below) is public and that a record of the Contribution, including my full name and email address among other information, will be maintained indefinitely and may be redistributed consistent with this project, compliance with the open source license(s) involved, and maintenance of authorship attribution.

DEFINITIONS.

"You" (or "Your") shall mean the copyright owner or legal entity authorized by the copyright owner that is making this Agreement with Snowflake. For legal entities, the entity making a Contribution and all other entities that control, are controlled by, or are under common control with that entity are considered to be a single Contributor. For the purposes of this definition, "control" means (i) the power, direct or indirect, to cause the direction or management of such entity, whether by contract or otherwise, or (ii) ownership of fifty percent (50%) or more of the outstanding shares, or (iii) beneficial ownership of such entity.

"Contribution" shall mean any original work of authorship, including any modifications or additions to an existing work, that is intentionally submitted by You to Snowflake (the “Work”). For the purposes of this definition, "submitted" means any form of electronic, verbal, or written communication sent to Snowflake or its representatives, including but not limited to communication on electronic mailing lists, source code control systems, and issue tracking systems that are managed by, or on behalf of, Snowflake for the purpose of discussing and improving the Work, but excluding communication that is conspicuously marked or otherwise designated in writing by You as "Not a Contribution."

GRANT OF COPYRIGHT LICENSE. Subject to the terms and conditions of this Agreement, You hereby grant to Snowflake and to recipients and/or users of software distributed and/or made available by Snowflake a perpetual, worldwide, non-exclusive, no-charge, royalty-free, irrevocable copyright license to reproduce, prepare derivative works of, publicly display, publicly perform, sublicense, and distribute Your Contributions and such derivative works.

GRANT OF PATENT LICENSE. Subject to the terms and conditions of this Agreement, You hereby grant to Snowflake and to recipients and/or users of software distributed and/or made available by Snowflake a perpetual, worldwide, non-exclusive, no-charge, royalty-free, irrevocable (except as stated in this section) patent license to make, have made, use, offer to sell, sell, import, and otherwise transfer the Work, where such license applies only to those patent claims licensable by You that are necessarily infringed by Your Contribution(s) alone or by combination of Your Contribution(s) with the Work to which such Contribution(s) were submitted. If any entity institutes patent litigation against You or any other entity (including a cross-claim or counterclaim in a lawsuit) alleging that your Contribution, or the Work to which you have contributed, constitutes direct or contributory patent infringement, then any patent licenses granted to that entity under this Agreement for that Contribution or Work shall terminate as of the date such litigation is filed.

REPRESENTATIONS.

You represent that You are legally entitled to grant the above licenses.

If You are an individual employed by another individual or a legal entity, You represent that Your employer has waived any of its rights in Your Contributions or that you have received permission to make Contributions on behalf of Your employer.

You represent that each of Your Contributions is Your original creation.

You represent that none of Your Contributions includes any third party copyrights, patents, trade secrets, licenses or other restrictions.

NO SUPPORT. You are not expected to provide support for Your Contributions, except to the extent You desire to provide support. You may provide support for free, for a fee, or not at all. Unless required by applicable law or agreed to in writing, You provide Your Contributions on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied, including, without limitation, any warranties or conditions of TITLE, NON-INFRINGEMENT, MERCHANTABILITY, or FITNESS FOR A PARTICULAR PURPOSE.

NOTICE TO SNOWFLAKE. You agree to notify Snowflake of any facts or circumstances of which you become aware that would make these representations inaccurate in any respect.

GOVERNING LAW & JURISDICTION. This Agreement shall be governed exclusively by, and construed exclusively in accordance with, the laws of the United States and the State of Delaware, without regard to its conflict of laws provisions. The state and federal courts located in Wilmington, Delaware shall have exclusive jurisdiction to adjudicate any dispute arising out of or relating to this Agreement.

ENTIRE AGREEMENT. This Agreement constitutes the entire agreement between the parties as to its subject matter and supersedes all prior and contemporaneous agreements, proposals or representations, written or oral, concerning the subject matter of this Agreement. No modification, amendment or waiver of any provision of this Agreement shall be effective unless in writing, accepted, and agreed to by the party against whom the modification, amendment or waiver is to be asserted. This Agreement does not supersede or amend any existing agreement between the parties for the purchase or use of either party’s products or services.

GENERAL. No failure or delay by You or Snowflake in exercising any right under this Agreement shall constitute a waiver of that right. Other than as expressly stated herein, the remedies herein are in addition to, and not exclusive of, any other remedies of a party at law or in equity. Should any provision of this Agreement be held by a court to be unenforceable, such provision shall be modified by the court and interpreted so as to best to accomplish the objectives of the original provision to the fullest extent permitted by law, and the remaining provisions of this Agreement shall remain in full force and effect.

ChuliangXiao avatar Jun 22 '22 13:06 ChuliangXiao

Snowflake Open Source Contribution

Terms and Conditions

By accepting and agreeing to this contributor license agreement, I understand and agree that my Contribution (as defined below) is public and that a record of the Contribution, including my full name and email address among other information, will be maintained indefinitely and may be redistributed consistent with this project, compliance with the open source license(s) involved, and maintenance of authorship attribution.

DEFINITIONS.

"You" (or "Your") shall mean the copyright owner or legal entity authorized by the copyright owner that is making this Agreement with Snowflake. For legal entities, the entity making a Contribution and all other entities that control, are controlled by, or are under common control with that entity are considered to be a single Contributor. For the purposes of this definition, "control" means (i) the power, direct or indirect, to cause the direction or management of such entity, whether by contract or otherwise, or (ii) ownership of fifty percent (50%) or more of the outstanding shares, or (iii) beneficial ownership of such entity.

"Contribution" shall mean any original work of authorship, including any modifications or additions to an existing work, that is intentionally submitted by You to Snowflake (the “Work”). For the purposes of this definition, "submitted" means any form of electronic, verbal, or written communication sent to Snowflake or its representatives, including but not limited to communication on electronic mailing lists, source code control systems, and issue tracking systems that are managed by, or on behalf of, Snowflake for the purpose of discussing and improving the Work, but excluding communication that is conspicuously marked or otherwise designated in writing by You as "Not a Contribution."

GRANT OF COPYRIGHT LICENSE. Subject to the terms and conditions of this Agreement, You hereby grant to Snowflake and to recipients and/or users of software distributed and/or made available by Snowflake a perpetual, worldwide, non-exclusive, no-charge, royalty-free, irrevocable copyright license to reproduce, prepare derivative works of, publicly display, publicly perform, sublicense, and distribute Your Contributions and such derivative works.

GRANT OF PATENT LICENSE. Subject to the terms and conditions of this Agreement, You hereby grant to Snowflake and to recipients and/or users of software distributed and/or made available by Snowflake a perpetual, worldwide, non-exclusive, no-charge, royalty-free, irrevocable (except as stated in this section) patent license to make, have made, use, offer to sell, sell, import, and otherwise transfer the Work, where such license applies only to those patent claims licensable by You that are necessarily infringed by Your Contribution(s) alone or by combination of Your Contribution(s) with the Work to which such Contribution(s) were submitted. If any entity institutes patent litigation against You or any other entity (including a cross-claim or counterclaim in a lawsuit) alleging that your Contribution, or the Work to which you have contributed, constitutes direct or contributory patent infringement, then any patent licenses granted to that entity under this Agreement for that Contribution or Work shall terminate as of the date such litigation is filed.

REPRESENTATIONS.

You represent that You are legally entitled to grant the above licenses.

If You are an individual employed by another individual or a legal entity, You represent that Your employer has waived any of its rights in Your Contributions or that you have received permission to make Contributions on behalf of Your employer.

You represent that each of Your Contributions is Your original creation.

You represent that none of Your Contributions includes any third party copyrights, patents, trade secrets, licenses or other restrictions.

NO SUPPORT. You are not expected to provide support for Your Contributions, except to the extent You desire to provide support. You may provide support for free, for a fee, or not at all. Unless required by applicable law or agreed to in writing, You provide Your Contributions on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied, including, without limitation, any warranties or conditions of TITLE, NON-INFRINGEMENT, MERCHANTABILITY, or FITNESS FOR A PARTICULAR PURPOSE.

NOTICE TO SNOWFLAKE. You agree to notify Snowflake of any facts or circumstances of which you become aware that would make these representations inaccurate in any respect.

GOVERNING LAW & JURISDICTION. This Agreement shall be governed exclusively by, and construed exclusively in accordance with, the laws of the United States and the State of Delaware, without regard to its conflict of laws provisions. The state and federal courts located in Wilmington, Delaware shall have exclusive jurisdiction to adjudicate any dispute arising out of or relating to this Agreement.

ENTIRE AGREEMENT. This Agreement constitutes the entire agreement between the parties as to its subject matter and supersedes all prior and contemporaneous agreements, proposals or representations, written or oral, concerning the subject matter of this Agreement. No modification, amendment or waiver of any provision of this Agreement shall be effective unless in writing, accepted, and agreed to by the party against whom the modification, amendment or waiver is to be asserted. This Agreement does not supersede or amend any existing agreement between the parties for the purchase or use of either party’s products or services.

GENERAL. No failure or delay by You or Snowflake in exercising any right under this Agreement shall constitute a waiver of that right. Other than as expressly stated herein, the remedies herein are in addition to, and not exclusive of, any other remedies of a party at law or in equity. Should any provision of this Agreement be held by a court to be unenforceable, such provision shall be modified by the court and interpreted so as to best to accomplish the objectives of the original provision to the fullest extent permitted by law, and the remaining provisions of this Agreement shall remain in full force and effect.

Sorry for the confusion, you need to copy, paste and comment

I have read the CLA Document and I hereby sign the CLA

sfc-gh-jdu avatar Jun 22 '22 18:06 sfc-gh-jdu

I have read the CLA Document and I hereby sign the CLA

ChuliangXiao avatar Jun 22 '22 19:06 ChuliangXiao