posthog icon indicating copy to clipboard operation
posthog copied to clipboard

fix(data-warehouse): boolean values on data warehouse person properties

Open EDsCODE opened this issue 1 year ago • 1 comments

Problem

  • boolean values passed as strings are never converted to bool

Changes

  • we do bool conversions for regular filters. apply that logic to this too

👉 Stay up-to-date with PostHog coding conventions for a smoother review.

Does this work well for both Cloud and self-hosted?

How did you test this code?

EDsCODE avatar May 06 '24 22:05 EDsCODE

🔍 Existing Issues For Review

Your pull request is modifying functions with the following pre-existing issues:

📄 File: posthog/hogql/property.py

Function Unhandled Issue
property_to_expr TypeError: Property.init() missing 1 required positional argument: 'key' posthog.ta...
Event Count: 17
property_to_expr Cohort.DoesNotExist: Cohort matching query does not exist. posthog.tasks.tasks.process_...
Event Count: 7
property_to_expr NotImplementedError: property_to_expr for element selector only supports exact and is_not operators, not regex ...
Event Count: 4
property_to_expr NotImplementedError: property_to_expr for element selector only supports exact and is_not operators, not icontains ...
Event Count: 1
📄 File: posthog/hogql/query.py (Click to Expand)
Function Unhandled Issue
execute_hogql_query CHQueryErrorUnknownIdentifier: DB::Exception: Missing columns: '--events__override.distinct_id' '--events__override.person_id'... ...
Event Count: 2.3k
execute_hogql_query CHQueryErrorNoCommonType: DB::Exception: There is no supertype for types String, Float64 because some of them are String/Fi... ...
Event Count: 217
execute_hogql_query CHQueryErrorTypeMismatch: DB::Exception: Cannot convert string 17.4.1 to type Float64: while executing 'FUNCTION equals(toF... ...
Event Count: 152
execute_hogql_query CHQueryErrorIllegalTypeOfArgument: DB::Exception: Illegal type String of argument for aggregate function avg. Stack trace: ...
Event Count: 108
execute_hogql_query ValidationError: 1 validation error for HogQLQueryResponse posthog.tasks.tasks.process_...
Event Count: 101
---

Did you find this useful? React with a 👍 or 👎

sentry-io[bot] avatar May 06 '24 22:05 sentry-io[bot]