GitHub PullRequestReviewCommentEvent at 2014-02-27 20:33:14
Repository: presto
Actor: electrum
Payload: {"comment":{"url":"https://api.github.com/repos/facebook/presto/pulls/comments/10141072","id":10141072,"diff_hunk":"@@ -0,0 +1,107 @@\n+===================\n+Migrating From Hive\n+===================\n+\n+Presto uses ANSI SQL syntax and semantics, whereas Hive uses a SQL-like language called HiveQL which is loosely modeled after MySQL (which itself has many differences from ANSI SQL).\n+\n+In addition to the below, see this `Quora question`_.\n+\n+.. _`Quora question`: http://www.quora.com/Hive-computing/What-are-the-biggest-feature-gaps-between-HiveQL-and-SQL\n+\n+Use ANSI SQL syntax for identifiers and strings\n+-----------------------------------------------\n+\n+Strings are delimited with single quotes and identifiers are quoted with double quotes, not backquotes:","path":"presto-docs/src/main/sphinx/migration/from-hive.rst","position":14,"original_position":14,"commit_id":"2c40b9298c4133cb25b7543f41ffd4c1e0fd4e01","original_commit_id":"2c40b9298c4133cb25b7543f41ffd4c1e0fd4e01","user":{"login":"electrum","id":9230,"avatar_url":"https://avatars.githubusercontent.com/u/9230","gravatar_id":"47f6d7fe374642282d0095f502bd882b","url":"https://api.github.com/users/electrum","html_url":"https://github.com/electrum","followers_url":"https://api.github.com/users/electrum/followers","following_url":"https://api.github.com/users/electrum/following{/other_user}","gists_url":"https://api.github.com/users/electrum/gists{/gist_id}","starred_url":"https://api.github.com/users/electrum/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/electrum/subscriptions","organizations_url":"https://api.github.com/users/electrum/orgs","repos_url":"https://api.github.com/users/electrum/repos","events_url":"https://api.github.com/users/electrum/events{/privacy}","received_events_url":"https://api.github.com/users/electrum/received_events","type":"User","site_admin":false},"body":"At least for now, SQL is the default code type so you can use double :: and don't need the explicit code-block indicator.\r\n\r\n","created_at":"2014-02-27T20:33:14Z","updated_at":"2014-02-27T20:33:14Z","html_url":"https://github.com/facebook/presto/pull/1079#discussion_r10141072","pull_request_url":"https://api.github.com/repos/facebook/presto/pulls/1079","_links":{"self":{"href":"https://api.github.com/repos/facebook/presto/pulls/comments/10141072"},"html":{"href":"https://github.com/facebook/presto/pull/1079#discussion_r10141072"},"pull_request":{"href":"https://api.github.com/repos/facebook/presto/pulls/1079"}}}}