{"action":"created","issue":{"url":"https://api.github.com/repos/apache/carbondata/issues/2073","repository_url":"https://api.github.com/repos/apache/carbondata","labels_url":"https://api.github.com/repos/apache/carbondata/issues/2073/labels{/name}","comments_url":"https://api.github.com/repos/apache/carbondata/issues/2073/comments","events_url":"https://api.github.com/repos/apache/carbondata/issues/2073/events","html_url":"https://github.com/apache/carbondata/pull/2073","id":306143571,"number":2073,"title":"[CARBONDATA-2260] CarbonThriftServer should support store carbon table on S3","user":{"login":"xubo245","id":8759816,"avatar_url":"https://avatars1.githubusercontent.com/u/8759816?v=4","gravatar_id":"","url":"https://api.github.com/users/xubo245","html_url":"https://github.com/xubo245","followers_url":"https://api.github.com/users/xubo245/followers","following_url":"https://api.github.com/users/xubo245/following{/other_user}","gists_url":"https://api.github.com/users/xubo245/gists{/gist_id}","starred_url":"https://api.github.com/users/xubo245/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/xubo245/subscriptions","organizations_url":"https://api.github.com/users/xubo245/orgs","repos_url":"https://api.github.com/users/xubo245/repos","events_url":"https://api.github.com/users/xubo245/events{/privacy}","received_events_url":"https://api.github.com/users/xubo245/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-03-17T09:51:03Z","updated_at":"2018-03-17T09:54:54Z","closed_at":null,"author_association":"CONTRIBUTOR","pull_request":{"url":"https://api.github.com/repos/apache/carbondata/pulls/2073","html_url":"https://github.com/apache/carbondata/pull/2073","diff_url":"https://github.com/apache/carbondata/pull/2073.diff","patch_url":"https://github.com/apache/carbondata/pull/2073.patch"},"body":"CarbonThriftServer should support store carbon table on S3\r\n\r\n\r\nBe sure to do all of the following checklist to help us incorporate \r\nyour contribution quickly and easily:\r\n\r\n - [ ] Any interfaces changed?\r\n \r\n - [ ] Any backward compatibility impacted?\r\n \r\n - [ ] Document update required?\r\n\r\n - [ ] Testing done\r\n        Step 1: \r\n          start carbonThriftServer by  org.apache.carbondata.examples.CarbonThriftServerExample\r\n          User should use themselves storePath, AK, SK and endPoint\r\n      Step 2: \r\n          start beeline like:  beeline -u jdbc:hive2://192.168.0.206:10000\r\n         IP and port should provide\r\n\r\nTest example:\r\n\r\n\r\n```\r\nroot@ecs-909c:~# beeline -u jdbc:hive2://192.168.0.206:10000\r\nConnecting to jdbc:hive2://192.168.0.206:10000\r\n2018-03-17 17:44:29 INFO  Utils:310 - Supplied authorities: 192.168.0.206:10000\r\n2018-03-17 17:44:29 INFO  Utils:397 - Resolved authority: 192.168.0.206:10000\r\n2018-03-17 17:44:29 INFO  HiveConnection:203 - Will try to open client transport with JDBC Uri: jdbc:hive2://192.168.0.206:10000\r\nConnected to: Spark SQL (version 2.2.1)\r\nDriver: Hive JDBC (version 1.2.1.spark2)\r\nTransaction isolation: TRANSACTION_REPEATABLE_READ\r\nBeeline version 1.2.1.spark2 by Apache Hive\r\n0: jdbc:hive2://192.168.0.206:10000>  Drop table if exists local_table2;\r\n+---------+--+\r\n| Result  |\r\n+---------+--+\r\n+---------+--+\r\nNo rows selected (21.205 seconds)\r\n0: jdbc:hive2://192.168.0.206:10000>\r\n0: jdbc:hive2://192.168.0.206:10000> CREATE TABLE if not exists local_table2( shortField SHORT, intField INT, bigintField LONG, doubleField DOUBLE, stringField STRING, timestampField TIMESTAMP, decimalField DECIMAL(18,2), dateField DATE, charField CHAR(5), floatField FLOAT ) STORED BY 'carbondata' LOCATION 's3a://carbonstore/local_table2'  TBLPROPERTIES('SORT_COLUMNS'='');\r\n+---------+--+\r\n| Result  |\r\n+---------+--+\r\n+---------+--+\r\nNo rows selected (1.296 seconds)\r\n0: jdbc:hive2://192.168.0.206:10000>\r\n0: jdbc:hive2://192.168.0.206:10000>\r\n0: jdbc:hive2://192.168.0.206:10000> LOAD DATA LOCAL INPATH '/huawei/xubo/git/carbondata2/examples/spark2/src/main/resources/data1.csv' INTO TABLE local_table2 OPTIONS('HEADER'='true');\r\n+---------+--+\r\n| Result  |\r\n+---------+--+\r\n+---------+--+\r\nNo rows selected (3.339 seconds)\r\n0: jdbc:hive2://192.168.0.206:10000>\r\n0: jdbc:hive2://192.168.0.206:10000>  select * from local_table2;\r\n+-------------+-----------+--------------+--------------+--------------+------------------------+---------------+-------------+------------+-------------+--+\r\n| shortfield  | intfield  | bigintfield  | doublefield  | stringfield  |     timestampfield     | decimalfield  |  datefield  | charfield  | floatfield  |\r\n+-------------+-----------+--------------+--------------+--------------+------------------------+---------------+-------------+------------+-------------+--+\r\n| 1           | 10        | 1100         | 48.4         | spark        | 2015-04-23 12:01:01.0  | 1.23          | 2015-04-23  | aaa        | 2.5         |\r\n| 5           | 17        | 1140         | 43.4         | spark        | 2015-07-27 12:01:02.0  | 3.45          | 2015-07-27  | bbb        | 2.5         |\r\n| 1           | 11        | 1100         | 44.4         | flink        | 2015-05-23 12:01:03.0  | 23.23         | 2015-05-23  | ccc        | 2.5         |\r\n| 1           | 10        | 1150         | 43.4         | spark        | 2015-07-24 12:01:04.0  | 254.12        | 2015-07-24  | ddd        | 2.5         |\r\n| 1           | 10        | 1100         | 47.4         | spark        | 2015-07-23 12:01:05.0  | 876.14        | 2015-07-23  | eeee       | 3.5         |\r\n| 3           | 14        | 1160         | 43.4         | hive         | 2015-07-26 12:01:06.0  | 3454.32       | 2015-07-26  | ff         | 2.5         |\r\n| 2           | 10        | 1100         | 43.4         | impala       | 2015-07-23 12:01:07.0  | 456.98        | 2015-07-23  | ggg        | 2.5         |\r\n| 1           | 10        | 1100         | 43.4         | spark        | 2015-05-23 12:01:08.0  | 32.53         | 2015-05-23  | hhh        | 2.5         |\r\n| 4           | 16        | 1130         | 42.4         | impala       | 2015-07-23 12:01:09.0  | 67.23         | 2015-07-23  | iii        | 2.5         |\r\n| 1           | 10        | 1100         | 43.4         | spark        | 2015-07-23 12:01:10.0  | 832.23        | 2015-07-23  | jjj        | 2.5         |\r\n+-------------+-----------+--------------+--------------+--------------+------------------------+---------------+-------------+------------+-------------+--+\r\n10 rows selected (0.959 seconds)\r\n0: jdbc:hive2://192.168.0.206:10000>\r\n\r\n\r\n```\r\n       \r\n - [ ] For large changes, please consider breaking it into sub-tasks under an umbrella JIRA. \r\n\r\n"},"comment":{"url":"https://api.github.com/repos/apache/carbondata/issues/comments/373908156","html_url":"https://github.com/apache/carbondata/pull/2073#issuecomment-373908156","issue_url":"https://api.github.com/repos/apache/carbondata/issues/2073","id":373908156,"user":{"login":"CarbonDataQA","id":24402133,"avatar_url":"https://avatars0.githubusercontent.com/u/24402133?v=4","gravatar_id":"","url":"https://api.github.com/users/CarbonDataQA","html_url":"https://github.com/CarbonDataQA","followers_url":"https://api.github.com/users/CarbonDataQA/followers","following_url":"https://api.github.com/users/CarbonDataQA/following{/other_user}","gists_url":"https://api.github.com/users/CarbonDataQA/gists{/gist_id}","starred_url":"https://api.github.com/users/CarbonDataQA/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/CarbonDataQA/subscriptions","organizations_url":"https://api.github.com/users/CarbonDataQA/orgs","repos_url":"https://api.github.com/users/CarbonDataQA/repos","events_url":"https://api.github.com/users/CarbonDataQA/events{/privacy}","received_events_url":"https://api.github.com/users/CarbonDataQA/received_events","type":"User","site_admin":false},"created_at":"2018-03-17T09:54:54Z","updated_at":"2018-03-17T09:54:54Z","author_association":"NONE","body":"Build Failed  with Spark 2.1.0, Please check CI http://136.243.101.176:8080/job/ApacheCarbonPRBuilder1/4396/\n"}}
{"actor":{"display_login":"CarbonDataQA"}}