You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@druid.apache.org by "matthewfarrugia-haud (via GitHub)" <gi...@apache.org> on 2023/11/16 08:33:16 UTC

[I] During Batch Loading we get Unparsable Query but on Query View it works fine | Docker compose V28.0.0 (druid)

matthewfarrugia-haud opened a new issue, #15384:
URL: https://github.com/apache/druid/issues/15384

   We are getting in the UI when we try to do a batch file upload before we start loading. 
   
   ### Affected Version 
   
   The Druid version where the problem was encountered is version 28.0.0
   
   ### Description
   We have special characters during loading im not sure it this is causing the error or not. Other formats worked without any issues.
   When you use this in the query viewer and execute the query is parsed and data is loaded successful 
   
   ``` SQL
   REPLACE INTO "categorised_data" OVERWRITE ALL
   WITH "ext" AS (
     SELECT *
     FROM TABLE(
       EXTERN(
         '{"type":"local","baseDir":"/opt/shared/data","filter":"*.out"}',
         '{"type":"tsv","findColumnsFromHeader":true,"delimiter":"\u001f;","listDelimiter":"\u001e"}'
       )
     ) EXTEND ("tpdu_mt_oa" BIGINT, "sccp_calling_gt" BIGINT, "smsc_gt" BIGINT, "tpdu_user_data" VARCHAR, U&"category_list\001e" VARCHAR)
   )
   SELECT
     MILLIS_TO_TIMESTAMP("tpdu_mt_oa") AS "__time",
     "sccp_calling_gt",
     "smsc_gt",
     "tpdu_user_data",
     MV_TO_ARRAY(U&"category_list\001e") AS U&"category_list\001e"
   FROM "ext"
   PARTITIONED BY DAY
   ```
   sample:
   ```
   tpdu_mt_oa;sccp_calling_gt;smsc_gt;tpdu_user_data;category_list
   123234;123123123;12313123;hello;278
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org

Re: [I] During Batch Loading we get Unparsable Query but on Query View it works fine | Docker compose V28.0.0 (druid)

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] closed issue #15384: During Batch Loading we get Unparsable Query but on Query View it works fine | Docker compose V28.0.0
URL: https://github.com/apache/druid/issues/15384


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org

Re: [I] During Batch Loading we get Unparsable Query but on Query View it works fine | Docker compose V28.0.0 (druid)

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #15384:
URL: https://github.com/apache/druid/issues/15384#issuecomment-2305953388

   This issue has been marked as stale due to 280 days of inactivity.
   It will be closed in 4 weeks if no further activity occurs. If this issue is still
   relevant, please simply write any comment. Even if closed, you can still revive the
   issue at any time or discuss it on the dev@druid.apache.org list.
   Thank you for your contributions.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org

Re: [I] During Batch Loading we get Unparsable Query but on Query View it works fine | Docker compose V28.0.0 (druid)

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #15384:
URL: https://github.com/apache/druid/issues/15384#issuecomment-2362468768

   This issue has been closed due to lack of activity. If you think that
   is incorrect, or the issue requires additional review, you can revive the issue at
   any time.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org