nifi-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Austin Duncan <adun...@pyaanalytics.com>
Subject Re: putdatabaserecord
Date Wed, 15 Nov 2017 15:59:19 GMT
which logs do i need to check

On Wed, Nov 15, 2017 at 10:04 AM, Juan Pablo Gardella <
gardellajuanpablo@gmail.com> wrote:

> Could you check share the logs? Remember PostreSQL does not follow SQL
> standard
> <https://www.postgresql.org/docs/current/static/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS>
> :
>
> *"Quoting an identifier also makes it case-sensitive, whereas unquoted
> names are always folded to lower case. For example, the
> identifiers FOO, foo, and "foo" are considered the same by PostgreSQL,
> but "Foo" and "FOO" are different from these three and each other. (The
> folding of unquoted names to lower case in PostgreSQL is incompatible with
> the SQL standard, which says that unquoted names should be folded to upper
> case. Thus, foo should be equivalent to "FOO" not "foo" according to the
> standard. If you want to write portable applications you are advised to
> always quote a particular name or never quote it.)"*
>
> Maybe you need to use quoting.
>
>
> On Wed, 15 Nov 2017 at 11:59 Austin Duncan <aduncan@pyaanalytics.com>
> wrote:
>
>> All,
>>
>> I am using putdatabaserecord to insert into a postgres table. The input
>> is a flat json record that is being read by a jsonpath reader. The data
>> will be inserted but when i look at the table it appears that all of the
>> data is null. I also tried using a json tree reader and that didnt work
>> either. Any ideas?
>>
>>
>> --
>> ​Austin Duncan
>> *​Researcher​*
>>
>> PYA Analytics
>> 2220 Sutherland Avenue
>> <https://maps.google.com/?q=2220+Sutherland+AvenueKnoxville,+TN+37919+865&entry=gmail&source=g>
>> Knoxville, TN 37919
>> <https://maps.google.com/?q=2220+Sutherland+AvenueKnoxville,+TN+37919+865&entry=gmail&source=g>
>> 423-260-4172
>>
>> <https://maps.google.com/?q=2220+Sutherland+AvenueKnoxville,+TN+37919+865&entry=gmail&source=g>
>> <%28865%29%20684-2828>
>>
>


-- 
​Austin Duncan
*​Researcher​*

PYA Analytics
2220 Sutherland Avenue
<https://maps.google.com/?q=2220+Sutherland+AvenueKnoxville,+TN+37919+865&entry=gmail&source=g>
Knoxville, TN 37919
<https://maps.google.com/?q=2220+Sutherland+AvenueKnoxville,+TN+37919+865&entry=gmail&source=g>
423-260-4172
<https://maps.google.com/?q=2220+Sutherland+AvenueKnoxville,+TN+37919+865&entry=gmail&source=g>
<%28865%29%20684-2828>

Mime
View raw message