Filter on a range of columns (HBase)
Stay organized with collections
Save and categorize content based on your preferences.
Creates a limiting filter on a range of columns.
Explore further
For detailed documentation that includes this code sample, see the following:
Code sample
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],[],[[["\u003cp\u003eThis code snippet demonstrates how to use a column range filter to limit the columns returned within a specified range.\u003c/p\u003e\n"],["\u003cp\u003eThe filter targets the "cell_plan" column family and selects columns with qualifiers between "data_plan_01gb" (inclusive) and "data_plan_10gb" (exclusive).\u003c/p\u003e\n"],["\u003cp\u003eThe provided example uses the Java client library for Bigtable, requiring prior authentication setup using Application Default Credentials.\u003c/p\u003e\n"],["\u003cp\u003eThe filter can be applied to a \u003ccode\u003eScan\u003c/code\u003e operation to retrieve a subset of columns based on their qualifiers within a specified column family.\u003c/p\u003e\n"]]],[],null,["Creates a limiting filter on a range of columns.\n\nExplore further\n\n\nFor detailed documentation that includes this code sample, see the following:\n\n- [Use filters](/bigtable/docs/using-filters)\n\nCode sample \n\nJava\n\n\nTo learn how to install and use the client library for Bigtable, see\n[Bigtable client libraries](/bigtable/docs/reference/libraries).\n\n\nTo authenticate to Bigtable, set up Application Default Credentials.\nFor more information, see\n\n[Set up authentication for a local development environment](/docs/authentication/set-up-adc-local-dev-environment).\n\n public static void filterLimitColRange() {\n // TODO(developer): Replace these variables before running the sample.\n String projectId = \"my-project-id\";\n String instanceId = \"my-instance-id\";\n String tableId = \"mobile-time-series\";\n filterLimitColRange(projectId, instanceId, tableId);\n }\n\n public static void filterLimitColRange(String projectId, String instanceId, String tableId) {\n // A filter that matches cells whose column qualifiers are between data_plan_01gb and\n // data_plan_10gb in the column family cell_plan\n Filter filter =\n new ColumnRangeFilter(\n Bytes.toBytes(\"data_plan_01gb\"), true, Bytes.toBytes(\"data_plan_10gb\"), false);\n Scan scan = new Scan().addFamily(Bytes.toBytes(\"cell_plan\")).setFilter(filter).setMaxVersions();\n readWithFilter(projectId, instanceId, tableId, scan);\n }\n\nWhat's next\n\n\nTo search and filter code samples for other Google Cloud products, see the\n[Google Cloud sample browser](/docs/samples?product=bigtable)."]]