Shulou(Shulou.com)06/02 Report--

This article will explain in detail how to use Phoenix in Hbase. The content of the article is of high quality, so the editor shares it for you as a reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

Table names and column family names in 1.Hbase are case sensitive

If you use lowercase table names, you must put double quotation marks. If the table name and column family name are uppercase, there is no need for double quotation marks 2.Phoenix query client timeout

Error: Operation timed out. (state=TIM01,code=6000) java.sql.SQLTimeoutException: Operation timed out.

Solution: modify apache-phoenix-5.0.0-HBase-2.0-bin/bin/hbase-site.xml to add the following configuration

Phoenix.query.timeoutMs 3600000 hbase.rpc.timeout 3600000

The premise of synchronizing the 3.Phoenix secondary index table with the source data table

The addition, deletion, modification and query of the data source table must go through the Phoenix command line or the client to ensure that the secondary index table is synchronized with the source table. The Bulk Loading provided by Phoenix also ensures that the secondary index table is synchronized with the source data table.

The use of 4.Phoenix Bulk Loading

Use Loading via PSQL to import large quantities of data, note that the Loading via PSQL file must be a .csv suffix, otherwise the program will not recognize the data file.

Management and maintenance of 5.Phoenix table

The table created by Phoenix must specify primary key (corresponding to the rowkey of Hbase), the column had better specify the column family name, and the column type had better be specified as varchar. If you use Phoenix to operate Hbase, you must use Phoenix's api operation to delete the table. If you directly use Hbase's api operation, Phoenix can see the table but the operation table will report an error. Dropping a table through Phoenix's api also deletes a possible secondary index.

On how to use Phoenix in Hbase to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.