You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Jim Scott <js...@maprtech.com> on 2015/06/25 22:12:41 UTC
drill configuration setting - rows overwriting one another
Can anyone point me to a configuration setting (not maxwidth) that can
prevent having the drill output in the CLI from overwriting data that is
already in a row? (i.e. the data is not wrapping to a new line)
I have a query that when I select all the columns, the data in the columns
at the end overwrite the data from the columns at the beginning because
each row is only being written to a single line. It is NOT wrapping to the
next line.
Thanks!
Jim
Re: drill configuration setting - rows overwriting one another
Posted by Ted Dunning <te...@gmail.com>.
Not an answer, but sqlline lets you log results to a file. You can
probably then view the file using a better tool.
On Thu, Jun 25, 2015 at 4:12 PM, Jim Scott <js...@maprtech.com> wrote:
> Can anyone point me to a configuration setting (not maxwidth) that can
> prevent having the drill output in the CLI from overwriting data that is
> already in a row? (i.e. the data is not wrapping to a new line)
>
> I have a query that when I select all the columns, the data in the columns
> at the end overwrite the data from the columns at the beginning because
> each row is only being written to a single line. It is NOT wrapping to the
> next line.
>
> Thanks!
> Jim
>
Re: drill configuration setting - rows overwriting one another
Posted by Jacques Nadeau <ja...@apache.org>.
There were a number of changes in how SQLline displayed tables that had
changing widths to make presentation better. There is a possibility that
those changes are causing a problem. Can you file a JIRA with a simple
reproduction?
On Fri, Jun 26, 2015 at 6:47 AM, Jim Scott <js...@maprtech.com> wrote:
> That certainly rectified the issue. csv, tsv and vertical all work
> flawlessly.
>
> If I recall properly, when I use to run query with lots of columns I never
> had any problems like this. It also seems to have predated all the pretty
> coloring options that have been added. I can't recall having run lots of
> wide queries since those coloring options were added. I'm not saying one
> led to the other, perhaps just coincidence.
>
> On Thu, Jun 25, 2015 at 8:24 PM, Jacques Nadeau <ja...@apache.org>
> wrote:
>
> > Sounds like a bug in sqlline's output format. Try changing the output
> > format from table to csv to work around this.
> > On Jun 25, 2015 1:13 PM, "Jim Scott" <js...@maprtech.com> wrote:
> >
> > > Can anyone point me to a configuration setting (not maxwidth) that can
> > > prevent having the drill output in the CLI from overwriting data that
> is
> > > already in a row? (i.e. the data is not wrapping to a new line)
> > >
> > > I have a query that when I select all the columns, the data in the
> > columns
> > > at the end overwrite the data from the columns at the beginning because
> > > each row is only being written to a single line. It is NOT wrapping to
> > the
> > > next line.
> > >
> > > Thanks!
> > > Jim
> > >
> >
>
>
>
> --
> *Jim Scott*
> Director, Enterprise Strategy & Architecture
> +1 (347) 746-9281
>
> <http://www.mapr.com/>
> [image: MapR Technologies] <http://www.mapr.com>
>
> Now Available - Free Hadoop On-Demand Training
> <
> http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available
> >
>
Re: drill configuration setting - rows overwriting one another
Posted by Jim Scott <js...@maprtech.com>.
That certainly rectified the issue. csv, tsv and vertical all work
flawlessly.
If I recall properly, when I use to run query with lots of columns I never
had any problems like this. It also seems to have predated all the pretty
coloring options that have been added. I can't recall having run lots of
wide queries since those coloring options were added. I'm not saying one
led to the other, perhaps just coincidence.
On Thu, Jun 25, 2015 at 8:24 PM, Jacques Nadeau <ja...@apache.org> wrote:
> Sounds like a bug in sqlline's output format. Try changing the output
> format from table to csv to work around this.
> On Jun 25, 2015 1:13 PM, "Jim Scott" <js...@maprtech.com> wrote:
>
> > Can anyone point me to a configuration setting (not maxwidth) that can
> > prevent having the drill output in the CLI from overwriting data that is
> > already in a row? (i.e. the data is not wrapping to a new line)
> >
> > I have a query that when I select all the columns, the data in the
> columns
> > at the end overwrite the data from the columns at the beginning because
> > each row is only being written to a single line. It is NOT wrapping to
> the
> > next line.
> >
> > Thanks!
> > Jim
> >
>
--
*Jim Scott*
Director, Enterprise Strategy & Architecture
+1 (347) 746-9281
<http://www.mapr.com/>
[image: MapR Technologies] <http://www.mapr.com>
Now Available - Free Hadoop On-Demand Training
<http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available>
Re: drill configuration setting - rows overwriting one another
Posted by Ted Dunning <te...@gmail.com>.
Could also be a terminal setting bug.
On Thu, Jun 25, 2015 at 9:24 PM, Jacques Nadeau <ja...@apache.org> wrote:
> Sounds like a bug in sqlline's output format. Try changing the output
> format from table to csv to work around this.
> On Jun 25, 2015 1:13 PM, "Jim Scott" <js...@maprtech.com> wrote:
>
> > Can anyone point me to a configuration setting (not maxwidth) that can
> > prevent having the drill output in the CLI from overwriting data that is
> > already in a row? (i.e. the data is not wrapping to a new line)
> >
> > I have a query that when I select all the columns, the data in the
> columns
> > at the end overwrite the data from the columns at the beginning because
> > each row is only being written to a single line. It is NOT wrapping to
> the
> > next line.
> >
> > Thanks!
> > Jim
> >
>
Re: drill configuration setting - rows overwriting one another
Posted by Jacques Nadeau <ja...@apache.org>.
Sounds like a bug in sqlline's output format. Try changing the output
format from table to csv to work around this.
On Jun 25, 2015 1:13 PM, "Jim Scott" <js...@maprtech.com> wrote:
> Can anyone point me to a configuration setting (not maxwidth) that can
> prevent having the drill output in the CLI from overwriting data that is
> already in a row? (i.e. the data is not wrapping to a new line)
>
> I have a query that when I select all the columns, the data in the columns
> at the end overwrite the data from the columns at the beginning because
> each row is only being written to a single line. It is NOT wrapping to the
> next line.
>
> Thanks!
> Jim
>