CQLを使ã£ã¦ã€Cassandraã‚’SQLライクã«æ“作ã™ã‚‹ã€‚
CQLã§Cassandraã‚’æ“作ã™ã‚‹ CQLシェルをインストールã—ãŸã®ã§ã€ã•ã£ããCQLã§Cassandraã®ãƒ‡ãƒ¼ã‚¿ã‚’æ“作ã—ã¦ã¿ãŸã„ã¨æ€ã„ã¾ã™ã€‚ CQLã¯ã€Cassandra Query Languageã®ç•¥ã§ã€Cassandra版ã®SQLã§ã™ã€‚ Cassandra Query Language (CQL) v3.1.5 CQLã¯ã€SQLã¨ã»ã¼åŒã˜æ§‹æ–‡ã¨ãªã£ã¦ã„ã‚‹ã®ã§ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®çµŒé¨“ãŒã‚る人ãªã‚‰ã€èª°ã§ã‚‚ã™ãã«ç†è§£ã§ãã¾ã™ã€‚ ã‚ースペースを作æˆã™ã‚‹ã€‚ ã¾ãšã¯ã€ã‚ースペースを作æˆã—ã¾ã™ã€‚ ã‚ースペースã¯ã€MySQLã§ã„ã†ã¨ã“ã‚ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã™ã€‚ CREATE KEYSPACE | DataStax CQL 3.0 Documentation 今回ã¯ã€first_keyspaceã¨ã„ã†åå‰ã§ã‚ースペースを作æˆã—ã¾ã—ãŸã€‚ create keyspace first_keyspa
続ã„ã¦ã€CQL㸠- CLOVERðŸ€
cassandra-cliを触ã£ã¦ã¿ãŸã®ã§ã€ä»Šåº¦ã¯CQL（Cassandra Query Language）を使ã£ã¦ã¿ã¾ã™ã€‚ ã¨ã‚Šã‚ãˆãšã€æ¯”較ã®ãŸã‚cassandra-cliã§å…ˆã«ã‚ースペースを作æˆã—ã¦ãŠãã¾ã—ãŸã€‚ [default@unknown] create keyspace DEMO ... with placement_strategy = 'org.apache.cassandra.locator.SimpleStrategy' ... and strategy_options = {replication_factor:1}; 9e2f3541-c5e7-31de-95a3-98047e78a696 [default@unknown] use DEMO; Authenticated to keyspace: DEMO [default@DEMO] create clumn f
ã¨ã‚Šã‚ãˆãšã€cassandra-cliã‹ã‚‰ - CLOVERðŸ€
先週ã€Apache Cassandraをインストールã—ã¾ã—ãŸã€‚ ã§ã€ãã“ã§ãªãœã‹çµ‚ã‚ã£ã¦ã„ãŸã®ã§ã€ç¶šãを進ã‚よã†ã¨æ€ã„ã¾ã™ã€‚ã„ããªã‚Šãƒ—ãƒã‚°ãƒ©ãƒ ã‹ã‚‰æ“作ã™ã‚‹ã¨ã‹ã˜ã‚ƒãªãã¦ã€ã¾ãšã¯ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ãƒ„ールã‹ã‚‰ã„ãã®ãŒãã£ã¨ç„¡é›£ã§ã™ã‚ˆã。 ã¨ã‚Šã‚ãˆãšã€Cassandraã‚’èµ·å‹•ã—ã¦ã€‚ $ cassandra -f xss = -ea -javaagent:/usr/local/cassandra/current/lib/jamm-0.2.5.jar -XX:+UseThreadPriorities -XX:ThreadPriorityPolicy=42 -Xms1024M -Xmx1024M -Xmn200M -XX:+HeapDumpOnOutOfMemoryError -Xss180k INFO 15:20:08,890 Logging initialized 〜çœç•¥ã€œ INFO 15:29:18
unoh.github.com by unoh
ã“ã‚“ã«ã¡ã‚ã€7月ã«å…¥ç¤¾ã—ãŸã°ã‹ã‚Šã®@emorinsã§ã™ã€‚ é¡Œåã®é€šã‚Šã§ã™ãŒåˆ†æ•£ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ŽApache Cassandraã€ã‚’紹介ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ å°‘ã—å‰ã¯Hadoop(ã¨HBase)ã¨æ¯”較ã•ã‚Œã‚‹ã“ã¨ã®å¤šã‹ã£ãŸCassandraã§ã™ãŒã€æœ€è¿‘ã¯Hadoopã®äººæ°—ã«æŠ¼ã•ã‚Œã¤ã¤ã‚るよã†ã«ã‚‚æ„Ÿã˜ã¾ã™ã€‚ ã—ã‹ã—ã€Cassandraã¨Hadoopã¯ç‰¹å¾´ãŒç•°ãªã‚Šã€ã‚ˆã言ã‚れるã®ãŒCassandraã¯ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ 処ç†ã«å‘ãã€ä¸€è²«æ€§ã®ã‹ã‚ã‚Šã«å¯ç”¨æ€§ã‚’é‡è¦–ã—ã€ã¾ãŸHadoopã¨ã¯é•ã£ã¦å˜ä¸€éšœå®³ç‚¹ã‚‚ã‚ã‚Šã¾ã›ã‚“。 今日ã¯ãã‚“ãªHadoopã¨ã¯é•ã£ãŸé…力ã®ã‚る分散データベース『Apache Cassandraã€ã‚’ã¯ã˜ã‚ã¦ã¿ã¾ã—ょã†ã€‚ 目次 Cassandraã¨ã¯ アーã‚テクãƒãƒ£ Cassandraã®ç‰¹å¾´ コンシステンシレベル データモデル Memtableã¨SSTable セットアップ storage-conf
cassandra CLIメモ(Hishidama's Apache Cassandra CLI Memo)
CLIã«ã¯ï¼ˆã¨ã„ã†ã‹Cassandraã®ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆå´ã‹ã‚‰ï¼‰ã‚ースペースやカラムファミリーを作æˆã—ãŸã‚Šè¿½åŠ ・削除ã—ãŸã‚Šã™ã‚‹æ©Ÿèƒ½ã¯ç„¡ã„。 変更ã—ãŸã„å ´åˆã¯storage-conf.xmlã®Keyspaceã‚’ä¿®æ£ã—ã€Cassandraã‚’å†èµ·å‹•ã™ã‚‹å¿…è¦ãŒã‚る。 connect Cassandraã«æŽ¥ç¶šã™ã‚‹ã‚³ãƒžãƒ³ãƒ‰ã€‚ cassandra> connect localhost/9160 Connected to: "Test Cluster" on localhost/9160 接続ã«æˆåŠŸã™ã‚‹ã¨ã€ã‚¯ãƒ©ã‚¹ã‚¿ãƒ¼åãŒè¡¨ç¤ºã•ã‚Œã‚‹ã€‚ show cluster name 接続ä¸ã®ã‚¯ãƒ©ã‚¹ã‚¿ãƒ¼åを表示ã™ã‚‹ã‚³ãƒžãƒ³ãƒ‰ã€‚ →Thrift APIã®describe_cluster_name() cassandra> show cluster name Test Cluster show keyspaces クラスター内ã®ã‚
Tutorial — phpcassa v1.0.a.6 documentation
Tutorial¶ This tutorial is intended as an introduction to working with Cassandra and phpcassa. Prerequisites¶ Before we start, make sure that you have phpcassa installed. This tutorial also assumes that a Cassandra instance is running on the default host and port. Read the instructions for getting started with Cassandra. You can start Cassandra like so: Creating a Keyspace and Column Families¶ We
ClientOptions - Cassandra Wiki
CQL New projects should use CQL. Sending CQL over the wire is not hard, but clients here provide connection pooling, failover, and often other benefits like tracing support. The list of drivers is in the documentation here. Client authors, please send a pull request to include yours. Thrift For older Thrift clients, see ClientOptionsThrift. Internal API The StorageProxy API is available to JVM-bas
cassandraã«æŒ‘戦 ãã®10 PHP Clientã‚’å‹•ã‹ã—ã¦ã¿ã‚‹
cassandraã¨Thriftã®æº–å‚™ãŒå‡ºæ¥ãŸã®ã§ã€ ã„よã„よcassandra PHP clientを作ã£ã¦ã¿ã‚‹ã€‚ ã„ã¤ã‚‚ã®ã‚ˆã†ã«cassandraã‚’èµ·å‹•ã—ã¦ã€ ã¾ãšã¯ã€ã™ã§ã«å…¥ã£ã¦ã„るデータを確èªã™ã‚‹ã€‚ cassandra> get Keyspace1.Super1['store1']['item1'] => (column=title, value=ipod, timestamp=1267714302240) => (column=price, value=101, timestamp=1268052816239) => (column=description, value=ipod nano 8G / color:silver, timestamp=1268053455479) Returned 3 results. ã“ã®ãƒ‡ãƒ¼ã‚¿ã‚’PHPã‹ã‚‰å–å¾—ã§ãるサンプルを作ã£ã¦ã¿ãŸã€‚ コードã¯
Cassandraã¨HBaseã®æ¯”較ã—ã¦å…¥é–€ã™ã‚‹NoSQL
第10回Cassandra勉強会ã«ã¦ç™ºè¡¨ã—ãŸã‚¹ãƒ©ã‚¤ãƒ‰ã«ã€å‹‰å¼·ä¼šå¾Œã®ãƒ•ã‚£ãƒ¼ãƒ‰ãƒãƒƒã‚¯ã‚’åæ˜ ã•ã›ãŸç‰©ã§ã™ã€‚Read less
ウノウラボ Unoh Labs: PHPã§æš—å·åŒ–・復å·åŒ–ã‚ã‚Œã“ã‚Œ
GT Nitro: Car Game Drag Raceã¯ã€å…¸åž‹çš„ãªã‚«ãƒ¼ã‚²ãƒ¼ãƒ ã§ã¯ã‚ã‚Šã¾ã›ã‚“。ã“ã‚Œã¯ã‚¹ãƒ”ードã€ãƒ‘ワーã€ã‚¹ã‚ル全開ã®ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã§ã™ã€‚ブレーã‚ã¯å¿˜ã‚Œã¦ã€ã“ã‚Œã¯ãƒ‰ãƒ©ãƒƒã‚°ãƒ¬ãƒ¼ã‚¹ã€ãƒ™ã‚¤ãƒ“ーï¼å¤å…¸çš„ãªã‚¯ãƒ©ã‚·ãƒƒã‚¯ã‹ã‚‰æœªæ¥çš„ãªãƒ“ーストã¾ã§ã€æœ€ã‚‚クールã§é€Ÿã„車ã¨ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã§ãã¾ã™ã€‚スティックシフトをマスターã—ã€ãƒ‹ãƒˆãƒã‚’è³¢ã使ã£ã¦ç«¶äº‰ã‚’打ã¡ç ´ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã“ã®ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã¯ãã®ãƒªã‚¢ãƒ«ãªç‰©ç†å¦ã¨ç´ 晴らã—ã„グラフィックスã§ã‚ãªãŸã®å¿ƒã‚’爆発ã•ã›ã¾ã™ã€‚ã“ã‚Œã¾ã§ãƒ—レイã—ãŸã“ã¨ã®ãªã„よã†ãªã‚‚ã®ã§ã™ã€‚ GT Nitroã¯ã€ãƒªãƒ•ãƒ¬ãƒƒã‚¯ã‚¹ã¨ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã‚’試ã™ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã§ã™ã€‚æ£ã—ã„瞬間ã«ã‚®ã‚¢ã‚’シフトã—ã€ã‚¬ã‚¹ã‚’æ€ã„切りè¸ã‚€å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã¾ãŸã€å¤§ç‰©ãŸã¡ã¨ç«¶ã„ã¤ã¤ã€è»Šã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¨ã‚¢ãƒƒãƒ—グレードも行ã‚ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“。世界ä¸ã§æœ€é«˜ã®ãƒ‰ãƒ©ã‚¤ãƒãƒ¼ã¨è»Šã¨ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã«æŒ‘ã‚€ã“ã¨ã«ãªã‚Šã€ãƒ‰ãƒ©ãƒƒã‚°ãƒ¬ãƒ¼ã‚¹ã®çŽ‹å†
1
ランã‚ング
メンテナンス
ãŠçŸ¥ã‚‰ã›
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
Travis CI
CQL for Cassandra ãƒãƒ¼ãƒˆã‚·ãƒ¼ãƒˆ - Qiita
Google Code Archive - Long-term storage for Google Code Project Hosting.
{{#tags}}- {{label}}
{{/tags}}