nifi-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Juan Pablo Gardella <gardellajuanpa...@gmail.com>
Subject Re: putdatabaserecord
Date Wed, 15 Nov 2017 15:04:15 GMT
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>
>

Mime
View raw message