'how to write select- where- query in big table using python client module
New to big table, was able to inset data in bigtable using python ,, tried the snippet below to read rows for specific condition but it is returning all the rows.
rows = table.read_rows(
filter_=row_filters.ConditionalRowFilter(
base_filter=row_filters.RowFilterChain(
filters=[
row_filters.ColumnQualifierRegexFilter("random_number"),
row_filters.ValueRegexFilter("3278"),
]
)
)
)
Can we write something similar to the below sql code
select * from table name where random_number = "3278"
data is stored in this format
0
cc_sha:random_number
"3278"
cc_sha:al
"9srq2g908ptcm763"
cc_sha:pal
"hkmmj931cgi70wtm"
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
Solution | Source |
---|