Re: Drill SQL questions - JSON context

2023-08-18 Thread Paul Rogers
Hi Mike, Good progress! There are a number of factors to consider. Let's work through them one by one. First, try the simplest possible query: SELECT * FROM If you are using the row set mechanism, grab the schema and print it. (My memory is hazy, but I do believe that there are methods and

Drill SQL questions - JSON context

2023-08-18 Thread Mike Beckerle
I'm using Apache Daffodil in the mode where it outputs JSON data. (For the moment, until we build a tighter integration. This is my conceptual test framework for that integration.) I have parsed data to create this JSON which represents 2-level nested repeating subrecords. All the simple fields

Re: [PR] DRILL-8450: Add Data Type Inference to XML Format Plugin (drill)

2023-08-18 Thread via GitHub
mbeckerle commented on code in PR #2819: URL: https://github.com/apache/drill/pull/2819#discussion_r1298815764 ## contrib/storage-http/src/main/java/org/apache/drill/exec/store/http/HttpXmlOptions.java: ## @@ -111,7 +111,7 @@ public String toString() { public static class

Re: is there a way to provide inline array metadata to inform the xml_reader?

2023-08-18 Thread Charles Givre
Hey Mike, So it looks like I was wrong and the XML reader does not have the support for Arrays. However... Once DRILL-8450 is merged, I'll add the readers for arrays. The XML reader itself still won't be able to dynamically detect them until we finish the XSD support, but at least the infra

Re: [PR] DRILL-8450: Add Data Type Inference to XML Format Plugin (drill)

2023-08-18 Thread via GitHub
cgivre commented on PR #2819: URL: https://github.com/apache/drill/pull/2819#issuecomment-1684011222 @mbeckerle Could you please take another look. I had to fix a few things for a unit test. Thx! -- This is an automated message from the Apache Git Service. To respond to the message,