https://pinot.apache.org/ logo
Join Slack
Powered by
# general
  • m
    A company can be in many locations.
  • m
    So you may have a row/record in the table that looks like: 
    LinkedIn, [USA, India...]
  • m
    As you see, locations can have multiple value for a row/record. This is supported by making the column 
    locations
    as a multi-valued column.
  • m
    Does this make sense?
  • m
    @User
  • m
    Note, we are not talking about aggregations here
  • d
    yeah i am reading
  • d
    ok got it!
  • m
    Ok, now lets move to aggregations
  • m
    So up until now, almost all aggregation functions took one argument
  • d
    a kinf of column that is an "array" basically
  • m
    Up until now, aggregation functions could take only one arg: this arg is either a column name or an expression
  • m
    expression could be something like add(col1, col2), so you could do 
    sum(add(col1, col2)
  • m
    here 
    add
    is a transform function that is applied to each record before aggregating
  • k
    Suggest creating a channel for this?
  • m
    Sure
  • m
    @User could you create a channel (I am not sure what to name it)?
  • d
    we can name it aggregators ahah
  • m
    ok, creating
  • d
    hello everyone
    馃憢 2
  • n
    Hi All, Is the data types supported by Pinot are below
  • n
    路聽聽聽聽聽聽INT 路聽聽聽聽聽聽FLOAT 路聽聽聽聽聽聽LONG 路聽聽聽聽聽聽DOUBLE 路聽聽聽聽聽聽BYTES 路聽聽聽聽聽聽STRING (Allowed only for Dimensions聽column)
  • r
    Hi there, I am trying out map multi-value column features. I tried the following query
    Copy code
    select tags__KEYS, tags__VALUES from spanEventView where mapValue(tags__KEYS, 'LOGS', tags__VALUES) = 'no value' limit 2
    I am expecting no rows returned. Instead, I've got two rows back
    Copy code
    "resultTable": {
        "dataSchema": {
            "columnDataTypes": ["STRING_ARRAY", "STRING_ARRAY"],
            "columnNames": ["tags__KEYS", "tags__VALUES"]
        },
        "rows": [
            [
                ["FLAGS"],
                ["0"]
            ],
            [
                ["FLAGS"],
                ["0"]
            ]
        ]
    },
  • r
    is this something I missed in the query or is this a bug?
  • k
    Will look into it shortly.
  • k
    That query is not constructed correctly
  • k
    Copy code
    select tags__KEYS, tags__VALUES from spanEventView where tags__KEYS = 'LOGS' and tags__VALUES = "no value" and mapValue(tags__KEYS, 'LOGS', tags__VALUES) = 'no value'
  • r
    this query results in exception
    Copy code
    ProcessingException(errorCode: 450,
message: InternalError: <http://java.io|java.io>.IOException: Failed: HTTP error code: 500
at org.apache.pinot.controller.api.resources.PinotQueryResource.sendPostRaw(PinotQueryResource.java: 284)
at org.apache.pinot.controller.api.resources.PinotQueryResource.sendRequestRaw(PinotQueryResource.java: 322)
at org.apache.pinot.controller.api.resources.PinotQueryResource.getQueryResponse(PinotQueryResource.java: 204)
at org.apache.pinot.controller.api.resources.PinotQueryResource.handlePostSql(PinotQueryResource.java: 131)
at sun.reflect.GeneratedMethodAccessor370.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java: 43)
at java.lang.reflect.Method.invoke(Method.java: 498)
at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java: 52)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java: 124)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java: 167)
at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java: 219)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java: 79)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java: 469)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java: 391))
  • s
    Can you post the exception from broker or server log? It looks like the query failed on the server.
1...128129130...160Latest