Create Hue dashboard from HBase Table

[#1]

Hi All,

I am a newbie in Hue. I have a HBase table I would like to use for some analytics. Is there a way to connect it to Hue Dashboard?

Thanks,

Francesco

[#2]

@Francesco_Fa 

You will need to configure hue with credentials and information for hbase:

[hbase]
  # Comma-separated list of HBase Thrift servers for clusters in the format of '(name|host:port)'.
  # Use full hostname. If hbase.thrift.ssl.enabled in hbase-site is set to true, https will be used otherwise it will use http
  # If using Kerberos we assume GSSAPI SASL, not PLAIN.
  ## hbase_clusters=(Cluster|localhost:9090)

  # HBase configuration directory, where hbase-site.xml is located.
  ## hbase_conf_dir=/etc/hbase/conf

  # Hard limit of rows or columns per row fetched before truncating.
  ## truncate_limit = 500

  # Should come from hbase-site.xml, do not set. 'framed' is used to chunk up responses, used with the nonblocking server in Thrift but is not supported in Hue.
  # 'buffered' used to be the default of the HBase Thrift Server. Default is buffered when not set in hbase-site.xml.
  ## thrift_transport=buffered

  # Choose whether Hue should validate certificates received from the server.
  ## ssl_cert_ca_verify=true

Once you have the configuration working, you should be able to view hbase within the UI.

If this answer resolves your issue or allows you to move forward, please choose to ACCEPT this solution and close this topic. If you have further dialogue on this topic please comment here or feel free to private message me. If you have new questions related to your Use Case please create separate topic and feel free to tag me in your post.  

Thanks,

Steven @ DFHZ

[#3]

Hi @stevenmatison ,

thank you for your reply.

I already view HBase table in the UI. Maybe my previous question was not very clear. What I meant was, is there a way to use a HBase table as a data source for Hue Dashboard?

Thank you,

Francesco

[#4]

@Francesco_Fa   If you do not want to use embedded sqlite, the options available for this are:

1. Mysql
2. Postgres
3. Oracle

https://docs.gethue.com/administrator/administration/database/

If this answer resolves your issue or allows you to move forward, please choose to ACCEPT this solution and close this topic. If you have further dialogue on this topic please comment here or feel free to private message me. If you have new questions related to your Use Case please create separate topic and feel free to tag me in your post.  

Thanks,

Steven @ DFHZ