drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "南在南方" <i02...@qq.com>
Subject Error when querying data on HBASE
Date Tue, 27 May 2014 02:05:39 GMT
Hi there,When I run a query on HBASE database, the query just stick there with nothing returned.
It seems that sqlline process is dead. 
BTW, Is there any document of DRQL grammar?
 [root@fan bin]# ./sqlline -n admin -p admin -u jdbc:drill:zk=fan:2181,slave2:2181,slave3:2181
sqlline version 1.1.6
0: jdbc:drill:zk=fan:2181,slave2:2181,slave3:> select * from hbase.`students`;






my storage-plugins.json:


 {
  "storage":{
    dfs: {
      type: "file",
      connection: "file:///",
      workspaces: {
        "root" : {
          location: "/",
          writable: false
        },
        "tmp" : {
          location: "/tmp",
          writable: true,
          storageformat: "csv"
        }
      },
      formats: {
        "psv" : {
          type: "text",
          extensions: [ "tbl" ],
          delimiter: "|"
        },
        "csv" : {
          type: "text",
          extensions: [ "csv" ],
          delimiter: ","
        },
        "tsv" : {
          type: "text",
          extensions: [ "tsv" ],
          delimiter: "\t"
        },
        "parquet" : {
          type: "parquet"
        },
        "json" : {
          type: "json"
        }
      }
    },
    cp: {
      type: "file",
      connection: "classpath:///"
    },
   fan: {
      type: "file",
      connection: "hdfs://100.2.12.103:9000",
      workspaces: {
        "root" : {
          location: "/",
          writable: true,
	  storageformat:"parquet"
        },
        "tmp" : {
          location: "/tmp",
          writable: true,
          storageformat: "csv"
        }
      },
      formats: {
        "psv" : {
          type: "text",
          extensions: [ "tbl" ],
          delimiter: "|"
        },
        "csv" : {
          type: "text",
          extensions: [ "csv" ],
          delimiter: ","
        },
        "tsv" : {
          type: "text",
          extensions: [ "tsv" ],
          delimiter: "\t"
        },
        "parquet" : {
          type: "parquet"
        },
        "json" : {
          type: "json"
        }
      }
    },
	 hbase : {
      type:"hbase",
      config : {
        "hbase.zookeeper.quorum" : "fan,slave2,slave3",
        "hbase.zookeeper.property.clientPort" : 2222
      }
    }
  }
}
Mime
  • Unnamed multipart/alternative (inline, 8-Bit, 0 bytes)
View raw message