Mark, Sorry for taking a while to get back to you. I'm running something as simple as "select db_name() database_name". I had it run an insert statement just to make sure the connection is working as it should and I get a row inserted every second into the test table. Any valid query I run returns the same error of "org.apache.avro.SchemaParseException: empty name". Is there a way to turn up logging to see what's coming back?
On Mon, Sep 14, 2015 at 11:38 AM Mark Payne <[email protected]> wrote: > Tyler, > > Hmm I've not run into that. Can you share the query that you are running > with me? I'd like to try to replicate the issue locally. > > Thanks > -Mark > > > On Sep 14, 2015, at 12:21 PM, Tyler Hawkes <[email protected]> wrote: > > Mark, > > That worked, but now I'm getting a SchemaParseException for Avro telling > me that there's an empty name. I've tried several different ways of > aliasing the sql columns but I'm still getting the error. Ideas? > > On Mon, Sep 14, 2015 at 6:57 AM Mark Payne <[email protected]> wrote: > >> Tyler, >> >> The ExecuteSQL Processor expects to have incoming connections and will >> only run if it has >> an incoming FlowFile. I.e., it cannot be used as a "Source Processor." >> There is a ticket [1] to allow >> it to be the first Processor in the flow, but right now it will not run >> unless it has input. >> >> One way to work around this problem in the mean time is to instead use a >> GenerateFlowFile processor >> that is scheduled to run every 5 minutes instead. Then connect the >> GenerateFlowFile processor to >> ExecuteSQL. This way, the ExecuteSQL processor will receive input so that >> it runs every 5 minutes. >> >> Please let me know if this will work for you! >> >> Thanks >> -Mark >> >> [1] https://issues.apache.org/jira/browse/NIFI-932 >> >> >> ________________________________ >> > From: [email protected] >> > Date: Sun, 13 Sep 2015 23:00:18 -0600 >> > Subject: Help with ExecuteSQL >> > To: [email protected] >> > >> > I'm trying to push data from SQLServer to HDFS. I've successfully >> > enabled a DBCPConnectionPool (it only enables if it can connect. I've >> > checked this several different ways). I've set it to run a query on a >> > cron and a timer and it always shows that it's running, but isn't >> > returning any rows. I've changed the query to be something that always >> > returns a single row and even then it shows zero rows coming back but >> > the number of tasks over the last 5 minutes run is exactly what it >> > should be. The down stream components are stopped so I can see if the >> > queues are filling up and they sit at 0. >> > >> > I'm happy to provide any more information that's required. Any ideas on >> > what might be going on or how to see any logs of errors that might be >> > silently happening? >> > > >
