Re: [influxdb] InfluxDB import

[Sean Beckett]

The db1 points are being imported but immediately dropped because the
timestamps are from May but the retention period is 1 hour.

Still investigating why the db0 points aren't persisting.

On Tue, Oct 25, 2016 at 9:54 AM, Sean Beckett  wrote:

> https://github.com/influxdata/influxdb/issues/7516
>
> On Tue, Oct 25, 2016 at 9:32 AM, manish jain  wrote:
>
>> Thanks Sean. I will check it and will get back to you.
>> Much appreciated.
>>
>> Best regards,
>> Manish jain
>> +917738684730
>>
>> On 25-Oct-2016 8:59 PM, "Sean Beckett"  wrote:
>>
>>> I'm unable the import your trivial file, as well. I'm not sure why. I
>>> verified this import will work, though.
>>>
>>> On Tue, Oct 25, 2016 at 9:03 AM, manish jain 
>>> wrote:
>>>
 Hello Sean,
 Would it be possible for you to share a data file that can be used. I
 just need to demonstrate the influxDB import functionality to my team.
 Hence it's not data specific.

 So if you have a valid data/import file that I can use to check the
 functionality. Please share.

 Best regards,
 Manish jain
 +917738684730

 On 25-Oct-2016 8:30 PM, "Sean Beckett"  wrote:

> The data so far don't make sense. The writes appear to be successful
> but there doesn't appear to be anything in the database.
>
> Can you share the InfluxDB logs from when the import was processed?
> The previously shared log lines in your first message have nothing to do
> with writes or importing and are not indicative of anything.
>
> On Tue, Oct 25, 2016 at 4:19 AM, manish jain 
> wrote:
>
>> Hello Sean,
>> Please find below results -
>>
>> SELECT * FROM db0..cpu -
>>
>> [image: Inline image 3]
>>
>> SELECt * FROM db1.rp1.cpu
>> [image: Inline image 2]
>>
>>
>> Thanks and Regards,
>> Manish Jain
>> +917738684730
>>
>> On Mon, Oct 24, 2016 at 9:30 PM, Sean Beckett 
>> wrote:
>>
>>> What is returned by
>>>
>>> SELECT * FROM db0..cpu
>>> SELECt * FROM db1.rp1.cpu
>>>
>>> On Thu, Oct 20, 2016 at 12:48 AM, manish jain 
>>> wrote:
>>>
 Hello Sean,
 Please find inline outputs :-

 *SHOW RETENTION POLICIES ON db0*

 [image: Inline image 1]

 *SHOW RETENTION POLICIES ON db1*

 [image: Inline image 2]


 Thanks and Regards,
 Manish Jain
 +917738684730

 On Thu, Oct 20, 2016 at 12:01 AM, Sean Beckett 
 wrote:

> What do the following return?
>
> SHOW RETENTION POLICIES ON db0
> SHOW RETENTION POLICIES ON db1
>
> On Wed, Oct 19, 2016 at 2:49 AM, manish jain 
> wrote:
>
>> Hello Sean,
>> This is the import file i am using -
>> ---Cut--
>> ---
>>
>> # DDL
>> CREATE DATABASE db0
>> CREATE DATABASE db1
>> CREATE RETENTION POLICY rp1 ON db1 DURATION 1h REPLICATION 1
>>
>> # DML
>> # CONTEXT-DATABASE:db0
>> # CONTEXT-RETENTION-POLICY:autogen
>> cpu,host=server1 value=33.3 14640263350
>> cpu,host=server1 value=43.3 14640263950
>> cpu,host=server1 value=63.3 14640265750
>>
>> # CONTEXT-DATABASE:db1
>> # CONTEXT-RETENTION-POLICY:rp1
>> cpu,host=server1 value=73.3 14640263350
>> cpu,host=server1 value=83.3 14640263950
>> cpu,host=server1 value=93.3 14640265750
>>
>> ---Cut--
>> ---
>> After running this file like this :- [root@integration@DEV
>> influxdb]influx -import -path=first.txt
>> I get following output - which shows success-
>>
>> 2016/10/14 09:22:45 Processed 3 commands
>> 2016/10/14 09:22:45 Processed 6 inserts
>> 2016/10/14 09:22:45 Failed 0 inserts
>>
>> Attached Screenshot of my query to the database.
>>
>> Log file -
>>
>> [retention] 2016/10/19 03:28:26 retention policy shard deletion
>> check commencing
>> [retention] 2016/10/19 03:58:26 retention policy shard deletion
>> check commencing
>> [retention] 2016/10/19 04:28:26 retention policy shard deletion
>> check commencing
>> [retention] 2016/10/19 04:58:26 retention policy shard deletion
>> check commencing
>> [retention] 2016/10/19 05:28:26 retention policy shard deletion
>> check commencing
>> [retention] 2016/10/19 05:58:26 retention policy shard deletion
>> check commencing
>> [retention] 2016/10/19 06:28:26 retention policy shard deletion
>> check commencing
>>

Re: [influxdb] InfluxDB import

[Sean Beckett]

https://github.com/influxdata/influxdb/issues/7516

On Tue, Oct 25, 2016 at 9:32 AM, manish jain  wrote:

> Thanks Sean. I will check it and will get back to you.
> Much appreciated.
>
> Best regards,
> Manish jain
> +917738684730
>
> On 25-Oct-2016 8:59 PM, "Sean Beckett"  wrote:
>
>> I'm unable the import your trivial file, as well. I'm not sure why. I
>> verified this import will work, though.
>>
>> On Tue, Oct 25, 2016 at 9:03 AM, manish jain  wrote:
>>
>>> Hello Sean,
>>> Would it be possible for you to share a data file that can be used. I
>>> just need to demonstrate the influxDB import functionality to my team.
>>> Hence it's not data specific.
>>>
>>> So if you have a valid data/import file that I can use to check the
>>> functionality. Please share.
>>>
>>> Best regards,
>>> Manish jain
>>> +917738684730
>>>
>>> On 25-Oct-2016 8:30 PM, "Sean Beckett"  wrote:
>>>
 The data so far don't make sense. The writes appear to be successful
 but there doesn't appear to be anything in the database.

 Can you share the InfluxDB logs from when the import was processed? The
 previously shared log lines in your first message have nothing to do with
 writes or importing and are not indicative of anything.

 On Tue, Oct 25, 2016 at 4:19 AM, manish jain 
 wrote:

> Hello Sean,
> Please find below results -
>
> SELECT * FROM db0..cpu -
>
> [image: Inline image 3]
>
> SELECt * FROM db1.rp1.cpu
> [image: Inline image 2]
>
>
> Thanks and Regards,
> Manish Jain
> +917738684730
>
> On Mon, Oct 24, 2016 at 9:30 PM, Sean Beckett 
> wrote:
>
>> What is returned by
>>
>> SELECT * FROM db0..cpu
>> SELECt * FROM db1.rp1.cpu
>>
>> On Thu, Oct 20, 2016 at 12:48 AM, manish jain 
>> wrote:
>>
>>> Hello Sean,
>>> Please find inline outputs :-
>>>
>>> *SHOW RETENTION POLICIES ON db0*
>>>
>>> [image: Inline image 1]
>>>
>>> *SHOW RETENTION POLICIES ON db1*
>>>
>>> [image: Inline image 2]
>>>
>>>
>>> Thanks and Regards,
>>> Manish Jain
>>> +917738684730
>>>
>>> On Thu, Oct 20, 2016 at 12:01 AM, Sean Beckett 
>>> wrote:
>>>
 What do the following return?

 SHOW RETENTION POLICIES ON db0
 SHOW RETENTION POLICIES ON db1

 On Wed, Oct 19, 2016 at 2:49 AM, manish jain 
 wrote:

> Hello Sean,
> This is the import file i am using -
> ---Cut--
> ---
>
> # DDL
> CREATE DATABASE db0
> CREATE DATABASE db1
> CREATE RETENTION POLICY rp1 ON db1 DURATION 1h REPLICATION 1
>
> # DML
> # CONTEXT-DATABASE:db0
> # CONTEXT-RETENTION-POLICY:autogen
> cpu,host=server1 value=33.3 14640263350
> cpu,host=server1 value=43.3 14640263950
> cpu,host=server1 value=63.3 14640265750
>
> # CONTEXT-DATABASE:db1
> # CONTEXT-RETENTION-POLICY:rp1
> cpu,host=server1 value=73.3 14640263350
> cpu,host=server1 value=83.3 14640263950
> cpu,host=server1 value=93.3 14640265750
>
> ---Cut--
> ---
> After running this file like this :- [root@integration@DEV
> influxdb]influx -import -path=first.txt
> I get following output - which shows success-
>
> 2016/10/14 09:22:45 Processed 3 commands
> 2016/10/14 09:22:45 Processed 6 inserts
> 2016/10/14 09:22:45 Failed 0 inserts
>
> Attached Screenshot of my query to the database.
>
> Log file -
>
> [retention] 2016/10/19 03:28:26 retention policy shard deletion
> check commencing
> [retention] 2016/10/19 03:58:26 retention policy shard deletion
> check commencing
> [retention] 2016/10/19 04:28:26 retention policy shard deletion
> check commencing
> [retention] 2016/10/19 04:58:26 retention policy shard deletion
> check commencing
> [retention] 2016/10/19 05:28:26 retention policy shard deletion
> check commencing
> [retention] 2016/10/19 05:58:26 retention policy shard deletion
> check commencing
> [retention] 2016/10/19 06:28:26 retention policy shard deletion
> check commencing
> [retention] 2016/10/19 06:58:26 retention policy shard deletion
> check commencing
> [retention] 2016/10/19 07:28:26 retention policy shard deletion
> check commencing
> [retention] 2016/10/19 07:58:26 retention policy shard deletion
> check commencing
> [retention] 2016/10/19 08:28:26 retention policy shard deletion
> check commen

Re: [influxdb] InfluxDB import

[manish jain]

Thanks Sean. I will check it and will get back to you.
Much appreciated.

Best regards,
Manish jain
+917738684730

On 25-Oct-2016 8:59 PM, "Sean Beckett"  wrote:

> I'm unable the import your trivial file, as well. I'm not sure why. I
> verified this import will work, though.
>
> On Tue, Oct 25, 2016 at 9:03 AM, manish jain  wrote:
>
>> Hello Sean,
>> Would it be possible for you to share a data file that can be used. I
>> just need to demonstrate the influxDB import functionality to my team.
>> Hence it's not data specific.
>>
>> So if you have a valid data/import file that I can use to check the
>> functionality. Please share.
>>
>> Best regards,
>> Manish jain
>> +917738684730
>>
>> On 25-Oct-2016 8:30 PM, "Sean Beckett"  wrote:
>>
>>> The data so far don't make sense. The writes appear to be successful but
>>> there doesn't appear to be anything in the database.
>>>
>>> Can you share the InfluxDB logs from when the import was processed? The
>>> previously shared log lines in your first message have nothing to do with
>>> writes or importing and are not indicative of anything.
>>>
>>> On Tue, Oct 25, 2016 at 4:19 AM, manish jain 
>>> wrote:
>>>
 Hello Sean,
 Please find below results -

 SELECT * FROM db0..cpu -

 [image: Inline image 3]

 SELECt * FROM db1.rp1.cpu
 [image: Inline image 2]


 Thanks and Regards,
 Manish Jain
 +917738684730

 On Mon, Oct 24, 2016 at 9:30 PM, Sean Beckett 
 wrote:

> What is returned by
>
> SELECT * FROM db0..cpu
> SELECt * FROM db1.rp1.cpu
>
> On Thu, Oct 20, 2016 at 12:48 AM, manish jain 
> wrote:
>
>> Hello Sean,
>> Please find inline outputs :-
>>
>> *SHOW RETENTION POLICIES ON db0*
>>
>> [image: Inline image 1]
>>
>> *SHOW RETENTION POLICIES ON db1*
>>
>> [image: Inline image 2]
>>
>>
>> Thanks and Regards,
>> Manish Jain
>> +917738684730
>>
>> On Thu, Oct 20, 2016 at 12:01 AM, Sean Beckett 
>> wrote:
>>
>>> What do the following return?
>>>
>>> SHOW RETENTION POLICIES ON db0
>>> SHOW RETENTION POLICIES ON db1
>>>
>>> On Wed, Oct 19, 2016 at 2:49 AM, manish jain 
>>> wrote:
>>>
 Hello Sean,
 This is the import file i am using -
 ---Cut--
 ---

 # DDL
 CREATE DATABASE db0
 CREATE DATABASE db1
 CREATE RETENTION POLICY rp1 ON db1 DURATION 1h REPLICATION 1

 # DML
 # CONTEXT-DATABASE:db0
 # CONTEXT-RETENTION-POLICY:autogen
 cpu,host=server1 value=33.3 14640263350
 cpu,host=server1 value=43.3 14640263950
 cpu,host=server1 value=63.3 14640265750

 # CONTEXT-DATABASE:db1
 # CONTEXT-RETENTION-POLICY:rp1
 cpu,host=server1 value=73.3 14640263350
 cpu,host=server1 value=83.3 14640263950
 cpu,host=server1 value=93.3 14640265750

 ---Cut--
 ---
 After running this file like this :- [root@integration@DEV
 influxdb]influx -import -path=first.txt
 I get following output - which shows success-

 2016/10/14 09:22:45 Processed 3 commands
 2016/10/14 09:22:45 Processed 6 inserts
 2016/10/14 09:22:45 Failed 0 inserts

 Attached Screenshot of my query to the database.

 Log file -

 [retention] 2016/10/19 03:28:26 retention policy shard deletion
 check commencing
 [retention] 2016/10/19 03:58:26 retention policy shard deletion
 check commencing
 [retention] 2016/10/19 04:28:26 retention policy shard deletion
 check commencing
 [retention] 2016/10/19 04:58:26 retention policy shard deletion
 check commencing
 [retention] 2016/10/19 05:28:26 retention policy shard deletion
 check commencing
 [retention] 2016/10/19 05:58:26 retention policy shard deletion
 check commencing
 [retention] 2016/10/19 06:28:26 retention policy shard deletion
 check commencing
 [retention] 2016/10/19 06:58:26 retention policy shard deletion
 check commencing
 [retention] 2016/10/19 07:28:26 retention policy shard deletion
 check commencing
 [retention] 2016/10/19 07:58:26 retention policy shard deletion
 check commencing
 [retention] 2016/10/19 08:28:26 retention policy shard deletion
 check commencing



 Thanks and Regards,
 Manish Jain
 +917738684730

 On Fri, Oct 14, 2016 at 11:30 PM, Sean Beckett 
 wrote:

> Please share the DDL from the top of the import file.
>>

Re: [influxdb] InfluxDB import

[Sean Beckett]

I'm unable the import your trivial file, as well. I'm not sure why. I
verified this import will work, though.

On Tue, Oct 25, 2016 at 9:03 AM, manish jain  wrote:

> Hello Sean,
> Would it be possible for you to share a data file that can be used. I just
> need to demonstrate the influxDB import functionality to my team. Hence
> it's not data specific.
>
> So if you have a valid data/import file that I can use to check the
> functionality. Please share.
>
> Best regards,
> Manish jain
> +917738684730
>
> On 25-Oct-2016 8:30 PM, "Sean Beckett"  wrote:
>
>> The data so far don't make sense. The writes appear to be successful but
>> there doesn't appear to be anything in the database.
>>
>> Can you share the InfluxDB logs from when the import was processed? The
>> previously shared log lines in your first message have nothing to do with
>> writes or importing and are not indicative of anything.
>>
>> On Tue, Oct 25, 2016 at 4:19 AM, manish jain  wrote:
>>
>>> Hello Sean,
>>> Please find below results -
>>>
>>> SELECT * FROM db0..cpu -
>>>
>>> [image: Inline image 3]
>>>
>>> SELECt * FROM db1.rp1.cpu
>>> [image: Inline image 2]
>>>
>>>
>>> Thanks and Regards,
>>> Manish Jain
>>> +917738684730
>>>
>>> On Mon, Oct 24, 2016 at 9:30 PM, Sean Beckett  wrote:
>>>
 What is returned by

 SELECT * FROM db0..cpu
 SELECt * FROM db1.rp1.cpu

 On Thu, Oct 20, 2016 at 12:48 AM, manish jain 
 wrote:

> Hello Sean,
> Please find inline outputs :-
>
> *SHOW RETENTION POLICIES ON db0*
>
> [image: Inline image 1]
>
> *SHOW RETENTION POLICIES ON db1*
>
> [image: Inline image 2]
>
>
> Thanks and Regards,
> Manish Jain
> +917738684730
>
> On Thu, Oct 20, 2016 at 12:01 AM, Sean Beckett 
> wrote:
>
>> What do the following return?
>>
>> SHOW RETENTION POLICIES ON db0
>> SHOW RETENTION POLICIES ON db1
>>
>> On Wed, Oct 19, 2016 at 2:49 AM, manish jain 
>> wrote:
>>
>>> Hello Sean,
>>> This is the import file i am using -
>>> ---Cut--
>>> ---
>>>
>>> # DDL
>>> CREATE DATABASE db0
>>> CREATE DATABASE db1
>>> CREATE RETENTION POLICY rp1 ON db1 DURATION 1h REPLICATION 1
>>>
>>> # DML
>>> # CONTEXT-DATABASE:db0
>>> # CONTEXT-RETENTION-POLICY:autogen
>>> cpu,host=server1 value=33.3 14640263350
>>> cpu,host=server1 value=43.3 14640263950
>>> cpu,host=server1 value=63.3 14640265750
>>>
>>> # CONTEXT-DATABASE:db1
>>> # CONTEXT-RETENTION-POLICY:rp1
>>> cpu,host=server1 value=73.3 14640263350
>>> cpu,host=server1 value=83.3 14640263950
>>> cpu,host=server1 value=93.3 14640265750
>>>
>>> ---Cut--
>>> ---
>>> After running this file like this :- [root@integration@DEV
>>> influxdb]influx -import -path=first.txt
>>> I get following output - which shows success-
>>>
>>> 2016/10/14 09:22:45 Processed 3 commands
>>> 2016/10/14 09:22:45 Processed 6 inserts
>>> 2016/10/14 09:22:45 Failed 0 inserts
>>>
>>> Attached Screenshot of my query to the database.
>>>
>>> Log file -
>>>
>>> [retention] 2016/10/19 03:28:26 retention policy shard deletion
>>> check commencing
>>> [retention] 2016/10/19 03:58:26 retention policy shard deletion
>>> check commencing
>>> [retention] 2016/10/19 04:28:26 retention policy shard deletion
>>> check commencing
>>> [retention] 2016/10/19 04:58:26 retention policy shard deletion
>>> check commencing
>>> [retention] 2016/10/19 05:28:26 retention policy shard deletion
>>> check commencing
>>> [retention] 2016/10/19 05:58:26 retention policy shard deletion
>>> check commencing
>>> [retention] 2016/10/19 06:28:26 retention policy shard deletion
>>> check commencing
>>> [retention] 2016/10/19 06:58:26 retention policy shard deletion
>>> check commencing
>>> [retention] 2016/10/19 07:28:26 retention policy shard deletion
>>> check commencing
>>> [retention] 2016/10/19 07:58:26 retention policy shard deletion
>>> check commencing
>>> [retention] 2016/10/19 08:28:26 retention policy shard deletion
>>> check commencing
>>>
>>>
>>>
>>> Thanks and Regards,
>>> Manish Jain
>>> +917738684730
>>>
>>> On Fri, Oct 14, 2016 at 11:30 PM, Sean Beckett 
>>> wrote:
>>>
 Please share the DDL from the top of the import file.

 Dod you look in the logs? Are you sure you are querying the right
 database?

 On Fri, Oct 14, 2016 at 3:45 AM,  wrote:

> How can i see the data imported in the database.
> I reached till this step -
>
> [root@integration@DEV influxdb]influx -i

Re: [influxdb] InfluxDB import

[manish jain]

Hello Sean,
Would it be possible for you to share a data file that can be used. I just
need to demonstrate the influxDB import functionality to my team. Hence
it's not data specific.

So if you have a valid data/import file that I can use to check the
functionality. Please share.

Best regards,
Manish jain
+917738684730

On 25-Oct-2016 8:30 PM, "Sean Beckett"  wrote:

> The data so far don't make sense. The writes appear to be successful but
> there doesn't appear to be anything in the database.
>
> Can you share the InfluxDB logs from when the import was processed? The
> previously shared log lines in your first message have nothing to do with
> writes or importing and are not indicative of anything.
>
> On Tue, Oct 25, 2016 at 4:19 AM, manish jain  wrote:
>
>> Hello Sean,
>> Please find below results -
>>
>> SELECT * FROM db0..cpu -
>>
>> [image: Inline image 3]
>>
>> SELECt * FROM db1.rp1.cpu
>> [image: Inline image 2]
>>
>>
>> Thanks and Regards,
>> Manish Jain
>> +917738684730
>>
>> On Mon, Oct 24, 2016 at 9:30 PM, Sean Beckett  wrote:
>>
>>> What is returned by
>>>
>>> SELECT * FROM db0..cpu
>>> SELECt * FROM db1.rp1.cpu
>>>
>>> On Thu, Oct 20, 2016 at 12:48 AM, manish jain 
>>> wrote:
>>>
 Hello Sean,
 Please find inline outputs :-

 *SHOW RETENTION POLICIES ON db0*

 [image: Inline image 1]

 *SHOW RETENTION POLICIES ON db1*

 [image: Inline image 2]


 Thanks and Regards,
 Manish Jain
 +917738684730

 On Thu, Oct 20, 2016 at 12:01 AM, Sean Beckett 
 wrote:

> What do the following return?
>
> SHOW RETENTION POLICIES ON db0
> SHOW RETENTION POLICIES ON db1
>
> On Wed, Oct 19, 2016 at 2:49 AM, manish jain 
> wrote:
>
>> Hello Sean,
>> This is the import file i am using -
>> ---Cut--
>> ---
>>
>> # DDL
>> CREATE DATABASE db0
>> CREATE DATABASE db1
>> CREATE RETENTION POLICY rp1 ON db1 DURATION 1h REPLICATION 1
>>
>> # DML
>> # CONTEXT-DATABASE:db0
>> # CONTEXT-RETENTION-POLICY:autogen
>> cpu,host=server1 value=33.3 14640263350
>> cpu,host=server1 value=43.3 14640263950
>> cpu,host=server1 value=63.3 14640265750
>>
>> # CONTEXT-DATABASE:db1
>> # CONTEXT-RETENTION-POLICY:rp1
>> cpu,host=server1 value=73.3 14640263350
>> cpu,host=server1 value=83.3 14640263950
>> cpu,host=server1 value=93.3 14640265750
>>
>> ---Cut--
>> ---
>> After running this file like this :- [root@integration@DEV
>> influxdb]influx -import -path=first.txt
>> I get following output - which shows success-
>>
>> 2016/10/14 09:22:45 Processed 3 commands
>> 2016/10/14 09:22:45 Processed 6 inserts
>> 2016/10/14 09:22:45 Failed 0 inserts
>>
>> Attached Screenshot of my query to the database.
>>
>> Log file -
>>
>> [retention] 2016/10/19 03:28:26 retention policy shard deletion check
>> commencing
>> [retention] 2016/10/19 03:58:26 retention policy shard deletion check
>> commencing
>> [retention] 2016/10/19 04:28:26 retention policy shard deletion check
>> commencing
>> [retention] 2016/10/19 04:58:26 retention policy shard deletion check
>> commencing
>> [retention] 2016/10/19 05:28:26 retention policy shard deletion check
>> commencing
>> [retention] 2016/10/19 05:58:26 retention policy shard deletion check
>> commencing
>> [retention] 2016/10/19 06:28:26 retention policy shard deletion check
>> commencing
>> [retention] 2016/10/19 06:58:26 retention policy shard deletion check
>> commencing
>> [retention] 2016/10/19 07:28:26 retention policy shard deletion check
>> commencing
>> [retention] 2016/10/19 07:58:26 retention policy shard deletion check
>> commencing
>> [retention] 2016/10/19 08:28:26 retention policy shard deletion check
>> commencing
>>
>>
>>
>> Thanks and Regards,
>> Manish Jain
>> +917738684730
>>
>> On Fri, Oct 14, 2016 at 11:30 PM, Sean Beckett 
>> wrote:
>>
>>> Please share the DDL from the top of the import file.
>>>
>>> Dod you look in the logs? Are you sure you are querying the right
>>> database?
>>>
>>> On Fri, Oct 14, 2016 at 3:45 AM,  wrote:
>>>
 How can i see the data imported in the database.
 I reached till this step -

 [root@integration@DEV influxdb]influx -import -path=first.txt
 2016/10/14 09:22:45 Processed 3 commands
 2016/10/14 09:22:45 Processed 6 inserts
 2016/10/14 09:22:45 Failed 0 inserts

 Please help how i can see the measurements in the database.
 'Show measurements' shows nothing.

 --
 Remember to

Re: [influxdb] InfluxDB import

[Sean Beckett]

The data so far don't make sense. The writes appear to be successful but
there doesn't appear to be anything in the database.

Can you share the InfluxDB logs from when the import was processed? The
previously shared log lines in your first message have nothing to do with
writes or importing and are not indicative of anything.

On Tue, Oct 25, 2016 at 4:19 AM, manish jain  wrote:

> Hello Sean,
> Please find below results -
>
> SELECT * FROM db0..cpu -
>
> [image: Inline image 3]
>
> SELECt * FROM db1.rp1.cpu
> [image: Inline image 2]
>
>
> Thanks and Regards,
> Manish Jain
> +917738684730
>
> On Mon, Oct 24, 2016 at 9:30 PM, Sean Beckett  wrote:
>
>> What is returned by
>>
>> SELECT * FROM db0..cpu
>> SELECt * FROM db1.rp1.cpu
>>
>> On Thu, Oct 20, 2016 at 12:48 AM, manish jain 
>> wrote:
>>
>>> Hello Sean,
>>> Please find inline outputs :-
>>>
>>> *SHOW RETENTION POLICIES ON db0*
>>>
>>> [image: Inline image 1]
>>>
>>> *SHOW RETENTION POLICIES ON db1*
>>>
>>> [image: Inline image 2]
>>>
>>>
>>> Thanks and Regards,
>>> Manish Jain
>>> +917738684730
>>>
>>> On Thu, Oct 20, 2016 at 12:01 AM, Sean Beckett 
>>> wrote:
>>>
 What do the following return?

 SHOW RETENTION POLICIES ON db0
 SHOW RETENTION POLICIES ON db1

 On Wed, Oct 19, 2016 at 2:49 AM, manish jain 
 wrote:

> Hello Sean,
> This is the import file i am using -
> ---Cut--
> ---
>
> # DDL
> CREATE DATABASE db0
> CREATE DATABASE db1
> CREATE RETENTION POLICY rp1 ON db1 DURATION 1h REPLICATION 1
>
> # DML
> # CONTEXT-DATABASE:db0
> # CONTEXT-RETENTION-POLICY:autogen
> cpu,host=server1 value=33.3 14640263350
> cpu,host=server1 value=43.3 14640263950
> cpu,host=server1 value=63.3 14640265750
>
> # CONTEXT-DATABASE:db1
> # CONTEXT-RETENTION-POLICY:rp1
> cpu,host=server1 value=73.3 14640263350
> cpu,host=server1 value=83.3 14640263950
> cpu,host=server1 value=93.3 14640265750
>
> ---Cut--
> ---
> After running this file like this :- [root@integration@DEV
> influxdb]influx -import -path=first.txt
> I get following output - which shows success-
>
> 2016/10/14 09:22:45 Processed 3 commands
> 2016/10/14 09:22:45 Processed 6 inserts
> 2016/10/14 09:22:45 Failed 0 inserts
>
> Attached Screenshot of my query to the database.
>
> Log file -
>
> [retention] 2016/10/19 03:28:26 retention policy shard deletion check
> commencing
> [retention] 2016/10/19 03:58:26 retention policy shard deletion check
> commencing
> [retention] 2016/10/19 04:28:26 retention policy shard deletion check
> commencing
> [retention] 2016/10/19 04:58:26 retention policy shard deletion check
> commencing
> [retention] 2016/10/19 05:28:26 retention policy shard deletion check
> commencing
> [retention] 2016/10/19 05:58:26 retention policy shard deletion check
> commencing
> [retention] 2016/10/19 06:28:26 retention policy shard deletion check
> commencing
> [retention] 2016/10/19 06:58:26 retention policy shard deletion check
> commencing
> [retention] 2016/10/19 07:28:26 retention policy shard deletion check
> commencing
> [retention] 2016/10/19 07:58:26 retention policy shard deletion check
> commencing
> [retention] 2016/10/19 08:28:26 retention policy shard deletion check
> commencing
>
>
>
> Thanks and Regards,
> Manish Jain
> +917738684730
>
> On Fri, Oct 14, 2016 at 11:30 PM, Sean Beckett 
> wrote:
>
>> Please share the DDL from the top of the import file.
>>
>> Dod you look in the logs? Are you sure you are querying the right
>> database?
>>
>> On Fri, Oct 14, 2016 at 3:45 AM,  wrote:
>>
>>> How can i see the data imported in the database.
>>> I reached till this step -
>>>
>>> [root@integration@DEV influxdb]influx -import -path=first.txt
>>> 2016/10/14 09:22:45 Processed 3 commands
>>> 2016/10/14 09:22:45 Processed 6 inserts
>>> 2016/10/14 09:22:45 Failed 0 inserts
>>>
>>> Please help how i can see the measurements in the database.
>>> 'Show measurements' shows nothing.
>>>
>>> --
>>> Remember to include the version number!
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "InfluxData" group.
>>> To unsubscribe from this group and stop receiving emails from it,
>>> send an email to influxdb+unsubscr...@googlegroups.com.
>>> To post to this group, send email to influxdb@googlegroups.com.
>>> Visit this group at https://groups.google.com/group/influxdb.
>>> To view this discussion on the web visit
>>> https://groups.google.com/d/msgid/influ

Re: [influxdb] InfluxDB import

[manish jain]

Hello Sean,
Please find below results -

SELECT * FROM db0..cpu -

[image: Inline image 3]

SELECt * FROM db1.rp1.cpu
[image: Inline image 2]


Thanks and Regards,
Manish Jain
+917738684730

On Mon, Oct 24, 2016 at 9:30 PM, Sean Beckett  wrote:

> What is returned by
>
> SELECT * FROM db0..cpu
> SELECt * FROM db1.rp1.cpu
>
> On Thu, Oct 20, 2016 at 12:48 AM, manish jain  wrote:
>
>> Hello Sean,
>> Please find inline outputs :-
>>
>> *SHOW RETENTION POLICIES ON db0*
>>
>> [image: Inline image 1]
>>
>> *SHOW RETENTION POLICIES ON db1*
>>
>> [image: Inline image 2]
>>
>>
>> Thanks and Regards,
>> Manish Jain
>> +917738684730
>>
>> On Thu, Oct 20, 2016 at 12:01 AM, Sean Beckett  wrote:
>>
>>> What do the following return?
>>>
>>> SHOW RETENTION POLICIES ON db0
>>> SHOW RETENTION POLICIES ON db1
>>>
>>> On Wed, Oct 19, 2016 at 2:49 AM, manish jain 
>>> wrote:
>>>
 Hello Sean,
 This is the import file i am using -
 ---Cut--
 ---

 # DDL
 CREATE DATABASE db0
 CREATE DATABASE db1
 CREATE RETENTION POLICY rp1 ON db1 DURATION 1h REPLICATION 1

 # DML
 # CONTEXT-DATABASE:db0
 # CONTEXT-RETENTION-POLICY:autogen
 cpu,host=server1 value=33.3 14640263350
 cpu,host=server1 value=43.3 14640263950
 cpu,host=server1 value=63.3 14640265750

 # CONTEXT-DATABASE:db1
 # CONTEXT-RETENTION-POLICY:rp1
 cpu,host=server1 value=73.3 14640263350
 cpu,host=server1 value=83.3 14640263950
 cpu,host=server1 value=93.3 14640265750

 ---Cut--
 ---
 After running this file like this :- [root@integration@DEV
 influxdb]influx -import -path=first.txt
 I get following output - which shows success-

 2016/10/14 09:22:45 Processed 3 commands
 2016/10/14 09:22:45 Processed 6 inserts
 2016/10/14 09:22:45 Failed 0 inserts

 Attached Screenshot of my query to the database.

 Log file -

 [retention] 2016/10/19 03:28:26 retention policy shard deletion check
 commencing
 [retention] 2016/10/19 03:58:26 retention policy shard deletion check
 commencing
 [retention] 2016/10/19 04:28:26 retention policy shard deletion check
 commencing
 [retention] 2016/10/19 04:58:26 retention policy shard deletion check
 commencing
 [retention] 2016/10/19 05:28:26 retention policy shard deletion check
 commencing
 [retention] 2016/10/19 05:58:26 retention policy shard deletion check
 commencing
 [retention] 2016/10/19 06:28:26 retention policy shard deletion check
 commencing
 [retention] 2016/10/19 06:58:26 retention policy shard deletion check
 commencing
 [retention] 2016/10/19 07:28:26 retention policy shard deletion check
 commencing
 [retention] 2016/10/19 07:58:26 retention policy shard deletion check
 commencing
 [retention] 2016/10/19 08:28:26 retention policy shard deletion check
 commencing



 Thanks and Regards,
 Manish Jain
 +917738684730

 On Fri, Oct 14, 2016 at 11:30 PM, Sean Beckett 
 wrote:

> Please share the DDL from the top of the import file.
>
> Dod you look in the logs? Are you sure you are querying the right
> database?
>
> On Fri, Oct 14, 2016 at 3:45 AM,  wrote:
>
>> How can i see the data imported in the database.
>> I reached till this step -
>>
>> [root@integration@DEV influxdb]influx -import -path=first.txt
>> 2016/10/14 09:22:45 Processed 3 commands
>> 2016/10/14 09:22:45 Processed 6 inserts
>> 2016/10/14 09:22:45 Failed 0 inserts
>>
>> Please help how i can see the measurements in the database.
>> 'Show measurements' shows nothing.
>>
>> --
>> Remember to include the version number!
>> ---
>> You received this message because you are subscribed to the Google
>> Groups "InfluxData" group.
>> To unsubscribe from this group and stop receiving emails from it,
>> send an email to influxdb+unsubscr...@googlegroups.com.
>> To post to this group, send email to influxdb@googlegroups.com.
>> Visit this group at https://groups.google.com/group/influxdb.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/influxdb/a3319963-4b54-49d
>> e-969e-72330af701af%40googlegroups.com.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>
> --
> Sean Beckett
> Director of Support and Professional Services
> InfluxDB
>
> --
> Remember to include the version number!
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "InfluxData" group.
> To unsubscribe from this topic, visit https://groups.google.com/d/to
> pic/influxdb/NE1jUrAVLjo

Re: [influxdb] InfluxDB import

[Sean Beckett]

What is returned by

SELECT * FROM db0..cpu
SELECt * FROM db1.rp1.cpu

On Thu, Oct 20, 2016 at 12:48 AM, manish jain  wrote:

> Hello Sean,
> Please find inline outputs :-
>
> *SHOW RETENTION POLICIES ON db0*
>
> [image: Inline image 1]
>
> *SHOW RETENTION POLICIES ON db1*
>
> [image: Inline image 2]
>
>
> Thanks and Regards,
> Manish Jain
> +917738684730
>
> On Thu, Oct 20, 2016 at 12:01 AM, Sean Beckett  wrote:
>
>> What do the following return?
>>
>> SHOW RETENTION POLICIES ON db0
>> SHOW RETENTION POLICIES ON db1
>>
>> On Wed, Oct 19, 2016 at 2:49 AM, manish jain  wrote:
>>
>>> Hello Sean,
>>> This is the import file i am using -
>>> ---Cut--
>>> ---
>>>
>>> # DDL
>>> CREATE DATABASE db0
>>> CREATE DATABASE db1
>>> CREATE RETENTION POLICY rp1 ON db1 DURATION 1h REPLICATION 1
>>>
>>> # DML
>>> # CONTEXT-DATABASE:db0
>>> # CONTEXT-RETENTION-POLICY:autogen
>>> cpu,host=server1 value=33.3 14640263350
>>> cpu,host=server1 value=43.3 14640263950
>>> cpu,host=server1 value=63.3 14640265750
>>>
>>> # CONTEXT-DATABASE:db1
>>> # CONTEXT-RETENTION-POLICY:rp1
>>> cpu,host=server1 value=73.3 14640263350
>>> cpu,host=server1 value=83.3 14640263950
>>> cpu,host=server1 value=93.3 14640265750
>>>
>>> ---Cut--
>>> ---
>>> After running this file like this :- [root@integration@DEV
>>> influxdb]influx -import -path=first.txt
>>> I get following output - which shows success-
>>>
>>> 2016/10/14 09:22:45 Processed 3 commands
>>> 2016/10/14 09:22:45 Processed 6 inserts
>>> 2016/10/14 09:22:45 Failed 0 inserts
>>>
>>> Attached Screenshot of my query to the database.
>>>
>>> Log file -
>>>
>>> [retention] 2016/10/19 03:28:26 retention policy shard deletion check
>>> commencing
>>> [retention] 2016/10/19 03:58:26 retention policy shard deletion check
>>> commencing
>>> [retention] 2016/10/19 04:28:26 retention policy shard deletion check
>>> commencing
>>> [retention] 2016/10/19 04:58:26 retention policy shard deletion check
>>> commencing
>>> [retention] 2016/10/19 05:28:26 retention policy shard deletion check
>>> commencing
>>> [retention] 2016/10/19 05:58:26 retention policy shard deletion check
>>> commencing
>>> [retention] 2016/10/19 06:28:26 retention policy shard deletion check
>>> commencing
>>> [retention] 2016/10/19 06:58:26 retention policy shard deletion check
>>> commencing
>>> [retention] 2016/10/19 07:28:26 retention policy shard deletion check
>>> commencing
>>> [retention] 2016/10/19 07:58:26 retention policy shard deletion check
>>> commencing
>>> [retention] 2016/10/19 08:28:26 retention policy shard deletion check
>>> commencing
>>>
>>>
>>>
>>> Thanks and Regards,
>>> Manish Jain
>>> +917738684730
>>>
>>> On Fri, Oct 14, 2016 at 11:30 PM, Sean Beckett 
>>> wrote:
>>>
 Please share the DDL from the top of the import file.

 Dod you look in the logs? Are you sure you are querying the right
 database?

 On Fri, Oct 14, 2016 at 3:45 AM,  wrote:

> How can i see the data imported in the database.
> I reached till this step -
>
> [root@integration@DEV influxdb]influx -import -path=first.txt
> 2016/10/14 09:22:45 Processed 3 commands
> 2016/10/14 09:22:45 Processed 6 inserts
> 2016/10/14 09:22:45 Failed 0 inserts
>
> Please help how i can see the measurements in the database.
> 'Show measurements' shows nothing.
>
> --
> Remember to include the version number!
> ---
> You received this message because you are subscribed to the Google
> Groups "InfluxData" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to influxdb+unsubscr...@googlegroups.com.
> To post to this group, send email to influxdb@googlegroups.com.
> Visit this group at https://groups.google.com/group/influxdb.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/influxdb/a3319963-4b54-49d
> e-969e-72330af701af%40googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>



 --
 Sean Beckett
 Director of Support and Professional Services
 InfluxDB

 --
 Remember to include the version number!
 ---
 You received this message because you are subscribed to a topic in the
 Google Groups "InfluxData" group.
 To unsubscribe from this topic, visit https://groups.google.com/d/to
 pic/influxdb/NE1jUrAVLjo/unsubscribe.
 To unsubscribe from this group and all its topics, send an email to
 influxdb+unsubscr...@googlegroups.com.
 To post to this group, send email to influxdb@googlegroups.com.
 Visit this group at https://groups.google.com/group/influxdb.
 To view this discussion on the web visit https://groups.google.com/d/ms
 gid/influxdb/CALGqCvPk7MoF2rVFtU%2BKM8dVWsk5%3DSt9fG2

Re: [influxdb] InfluxDB import

[manish jain]

Hello Sean,
Please find inline outputs :-

*SHOW RETENTION POLICIES ON db0*

[image: Inline image 1]

*SHOW RETENTION POLICIES ON db1*

[image: Inline image 2]


Thanks and Regards,
Manish Jain
+917738684730

On Thu, Oct 20, 2016 at 12:01 AM, Sean Beckett  wrote:

> What do the following return?
>
> SHOW RETENTION POLICIES ON db0
> SHOW RETENTION POLICIES ON db1
>
> On Wed, Oct 19, 2016 at 2:49 AM, manish jain  wrote:
>
>> Hello Sean,
>> This is the import file i am using -
>> ---Cut--
>> ---
>>
>> # DDL
>> CREATE DATABASE db0
>> CREATE DATABASE db1
>> CREATE RETENTION POLICY rp1 ON db1 DURATION 1h REPLICATION 1
>>
>> # DML
>> # CONTEXT-DATABASE:db0
>> # CONTEXT-RETENTION-POLICY:autogen
>> cpu,host=server1 value=33.3 14640263350
>> cpu,host=server1 value=43.3 14640263950
>> cpu,host=server1 value=63.3 14640265750
>>
>> # CONTEXT-DATABASE:db1
>> # CONTEXT-RETENTION-POLICY:rp1
>> cpu,host=server1 value=73.3 14640263350
>> cpu,host=server1 value=83.3 14640263950
>> cpu,host=server1 value=93.3 14640265750
>>
>> ---Cut--
>> ---
>> After running this file like this :- [root@integration@DEV
>> influxdb]influx -import -path=first.txt
>> I get following output - which shows success-
>>
>> 2016/10/14 09:22:45 Processed 3 commands
>> 2016/10/14 09:22:45 Processed 6 inserts
>> 2016/10/14 09:22:45 Failed 0 inserts
>>
>> Attached Screenshot of my query to the database.
>>
>> Log file -
>>
>> [retention] 2016/10/19 03:28:26 retention policy shard deletion check
>> commencing
>> [retention] 2016/10/19 03:58:26 retention policy shard deletion check
>> commencing
>> [retention] 2016/10/19 04:28:26 retention policy shard deletion check
>> commencing
>> [retention] 2016/10/19 04:58:26 retention policy shard deletion check
>> commencing
>> [retention] 2016/10/19 05:28:26 retention policy shard deletion check
>> commencing
>> [retention] 2016/10/19 05:58:26 retention policy shard deletion check
>> commencing
>> [retention] 2016/10/19 06:28:26 retention policy shard deletion check
>> commencing
>> [retention] 2016/10/19 06:58:26 retention policy shard deletion check
>> commencing
>> [retention] 2016/10/19 07:28:26 retention policy shard deletion check
>> commencing
>> [retention] 2016/10/19 07:58:26 retention policy shard deletion check
>> commencing
>> [retention] 2016/10/19 08:28:26 retention policy shard deletion check
>> commencing
>>
>>
>>
>> Thanks and Regards,
>> Manish Jain
>> +917738684730
>>
>> On Fri, Oct 14, 2016 at 11:30 PM, Sean Beckett  wrote:
>>
>>> Please share the DDL from the top of the import file.
>>>
>>> Dod you look in the logs? Are you sure you are querying the right
>>> database?
>>>
>>> On Fri, Oct 14, 2016 at 3:45 AM,  wrote:
>>>
 How can i see the data imported in the database.
 I reached till this step -

 [root@integration@DEV influxdb]influx -import -path=first.txt
 2016/10/14 09:22:45 Processed 3 commands
 2016/10/14 09:22:45 Processed 6 inserts
 2016/10/14 09:22:45 Failed 0 inserts

 Please help how i can see the measurements in the database.
 'Show measurements' shows nothing.

 --
 Remember to include the version number!
 ---
 You received this message because you are subscribed to the Google
 Groups "InfluxData" group.
 To unsubscribe from this group and stop receiving emails from it, send
 an email to influxdb+unsubscr...@googlegroups.com.
 To post to this group, send email to influxdb@googlegroups.com.
 Visit this group at https://groups.google.com/group/influxdb.
 To view this discussion on the web visit https://groups.google.com/d/ms
 gid/influxdb/a3319963-4b54-49de-969e-72330af701af%40googlegroups.com.
 For more options, visit https://groups.google.com/d/optout.

>>>
>>>
>>>
>>> --
>>> Sean Beckett
>>> Director of Support and Professional Services
>>> InfluxDB
>>>
>>> --
>>> Remember to include the version number!
>>> ---
>>> You received this message because you are subscribed to a topic in the
>>> Google Groups "InfluxData" group.
>>> To unsubscribe from this topic, visit https://groups.google.com/d/to
>>> pic/influxdb/NE1jUrAVLjo/unsubscribe.
>>> To unsubscribe from this group and all its topics, send an email to
>>> influxdb+unsubscr...@googlegroups.com.
>>> To post to this group, send email to influxdb@googlegroups.com.
>>> Visit this group at https://groups.google.com/group/influxdb.
>>> To view this discussion on the web visit https://groups.google.com/d/ms
>>> gid/influxdb/CALGqCvPk7MoF2rVFtU%2BKM8dVWsk5%3DSt9fG2i%3DG40
>>> %3DW2LJSfVkQ%40mail.gmail.com
>>> 
>>> .
>>>
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>> --
>

Re: [influxdb] InfluxDB import

[Sean Beckett]

What do the following return?

SHOW RETENTION POLICIES ON db0
SHOW RETENTION POLICIES ON db1

On Wed, Oct 19, 2016 at 2:49 AM, manish jain  wrote:

> Hello Sean,
> This is the import file i am using -
> ---Cut--
> ---
>
> # DDL
> CREATE DATABASE db0
> CREATE DATABASE db1
> CREATE RETENTION POLICY rp1 ON db1 DURATION 1h REPLICATION 1
>
> # DML
> # CONTEXT-DATABASE:db0
> # CONTEXT-RETENTION-POLICY:autogen
> cpu,host=server1 value=33.3 14640263350
> cpu,host=server1 value=43.3 14640263950
> cpu,host=server1 value=63.3 14640265750
>
> # CONTEXT-DATABASE:db1
> # CONTEXT-RETENTION-POLICY:rp1
> cpu,host=server1 value=73.3 14640263350
> cpu,host=server1 value=83.3 14640263950
> cpu,host=server1 value=93.3 14640265750
>
> ---Cut--
> ---
> After running this file like this :- [root@integration@DEV
> influxdb]influx -import -path=first.txt
> I get following output - which shows success-
>
> 2016/10/14 09:22:45 Processed 3 commands
> 2016/10/14 09:22:45 Processed 6 inserts
> 2016/10/14 09:22:45 Failed 0 inserts
>
> Attached Screenshot of my query to the database.
>
> Log file -
>
> [retention] 2016/10/19 03:28:26 retention policy shard deletion check
> commencing
> [retention] 2016/10/19 03:58:26 retention policy shard deletion check
> commencing
> [retention] 2016/10/19 04:28:26 retention policy shard deletion check
> commencing
> [retention] 2016/10/19 04:58:26 retention policy shard deletion check
> commencing
> [retention] 2016/10/19 05:28:26 retention policy shard deletion check
> commencing
> [retention] 2016/10/19 05:58:26 retention policy shard deletion check
> commencing
> [retention] 2016/10/19 06:28:26 retention policy shard deletion check
> commencing
> [retention] 2016/10/19 06:58:26 retention policy shard deletion check
> commencing
> [retention] 2016/10/19 07:28:26 retention policy shard deletion check
> commencing
> [retention] 2016/10/19 07:58:26 retention policy shard deletion check
> commencing
> [retention] 2016/10/19 08:28:26 retention policy shard deletion check
> commencing
>
>
>
> Thanks and Regards,
> Manish Jain
> +917738684730
>
> On Fri, Oct 14, 2016 at 11:30 PM, Sean Beckett  wrote:
>
>> Please share the DDL from the top of the import file.
>>
>> Dod you look in the logs? Are you sure you are querying the right
>> database?
>>
>> On Fri, Oct 14, 2016 at 3:45 AM,  wrote:
>>
>>> How can i see the data imported in the database.
>>> I reached till this step -
>>>
>>> [root@integration@DEV influxdb]influx -import -path=first.txt
>>> 2016/10/14 09:22:45 Processed 3 commands
>>> 2016/10/14 09:22:45 Processed 6 inserts
>>> 2016/10/14 09:22:45 Failed 0 inserts
>>>
>>> Please help how i can see the measurements in the database.
>>> 'Show measurements' shows nothing.
>>>
>>> --
>>> Remember to include the version number!
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "InfluxData" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to influxdb+unsubscr...@googlegroups.com.
>>> To post to this group, send email to influxdb@googlegroups.com.
>>> Visit this group at https://groups.google.com/group/influxdb.
>>> To view this discussion on the web visit https://groups.google.com/d/ms
>>> gid/influxdb/a3319963-4b54-49de-969e-72330af701af%40googlegroups.com.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>
>>
>> --
>> Sean Beckett
>> Director of Support and Professional Services
>> InfluxDB
>>
>> --
>> Remember to include the version number!
>> ---
>> You received this message because you are subscribed to a topic in the
>> Google Groups "InfluxData" group.
>> To unsubscribe from this topic, visit https://groups.google.com/d/to
>> pic/influxdb/NE1jUrAVLjo/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to
>> influxdb+unsubscr...@googlegroups.com.
>> To post to this group, send email to influxdb@googlegroups.com.
>> Visit this group at https://groups.google.com/group/influxdb.
>> To view this discussion on the web visit https://groups.google.com/d/ms
>> gid/influxdb/CALGqCvPk7MoF2rVFtU%2BKM8dVWsk5%3DSt9fG2i%
>> 3DG40%3DW2LJSfVkQ%40mail.gmail.com
>> 
>> .
>>
>> For more options, visit https://groups.google.com/d/optout.
>>
>
> --
> Remember to include the version number!
> ---
> You received this message because you are subscribed to the Google Groups
> "InfluxData" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to influxdb+unsubscr...@googlegroups.com.
> To post to this group, send email to influxdb@googlegroups.com.
> Visit this group at https://groups.google.com/group/influxdb.
> T

Re: [influxdb] InfluxDB import

[manish jain]

Hello Sean,
This is the import file i am using -
---Cut-

# DDL
CREATE DATABASE db0
CREATE DATABASE db1
CREATE RETENTION POLICY rp1 ON db1 DURATION 1h REPLICATION 1

# DML
# CONTEXT-DATABASE:db0
# CONTEXT-RETENTION-POLICY:autogen
cpu,host=server1 value=33.3 14640263350
cpu,host=server1 value=43.3 14640263950
cpu,host=server1 value=63.3 14640265750

# CONTEXT-DATABASE:db1
# CONTEXT-RETENTION-POLICY:rp1
cpu,host=server1 value=73.3 14640263350
cpu,host=server1 value=83.3 14640263950
cpu,host=server1 value=93.3 14640265750

---Cut-
After running this file like this :- [root@integration@DEV influxdb]influx
-import -path=first.txt
I get following output - which shows success-

2016/10/14 09:22:45 Processed 3 commands
2016/10/14 09:22:45 Processed 6 inserts
2016/10/14 09:22:45 Failed 0 inserts

Attached Screenshot of my query to the database.

Log file -

[retention] 2016/10/19 03:28:26 retention policy shard deletion check
commencing
[retention] 2016/10/19 03:58:26 retention policy shard deletion check
commencing
[retention] 2016/10/19 04:28:26 retention policy shard deletion check
commencing
[retention] 2016/10/19 04:58:26 retention policy shard deletion check
commencing
[retention] 2016/10/19 05:28:26 retention policy shard deletion check
commencing
[retention] 2016/10/19 05:58:26 retention policy shard deletion check
commencing
[retention] 2016/10/19 06:28:26 retention policy shard deletion check
commencing
[retention] 2016/10/19 06:58:26 retention policy shard deletion check
commencing
[retention] 2016/10/19 07:28:26 retention policy shard deletion check
commencing
[retention] 2016/10/19 07:58:26 retention policy shard deletion check
commencing
[retention] 2016/10/19 08:28:26 retention policy shard deletion check
commencing



Thanks and Regards,
Manish Jain
+917738684730

On Fri, Oct 14, 2016 at 11:30 PM, Sean Beckett  wrote:

> Please share the DDL from the top of the import file.
>
> Dod you look in the logs? Are you sure you are querying the right database?
>
> On Fri, Oct 14, 2016 at 3:45 AM,  wrote:
>
>> How can i see the data imported in the database.
>> I reached till this step -
>>
>> [root@integration@DEV influxdb]influx -import -path=first.txt
>> 2016/10/14 09:22:45 Processed 3 commands
>> 2016/10/14 09:22:45 Processed 6 inserts
>> 2016/10/14 09:22:45 Failed 0 inserts
>>
>> Please help how i can see the measurements in the database.
>> 'Show measurements' shows nothing.
>>
>> --
>> Remember to include the version number!
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "InfluxData" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to influxdb+unsubscr...@googlegroups.com.
>> To post to this group, send email to influxdb@googlegroups.com.
>> Visit this group at https://groups.google.com/group/influxdb.
>> To view this discussion on the web visit https://groups.google.com/d/ms
>> gid/influxdb/a3319963-4b54-49de-969e-72330af701af%40googlegroups.com.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>
> --
> Sean Beckett
> Director of Support and Professional Services
> InfluxDB
>
> --
> Remember to include the version number!
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "InfluxData" group.
> To unsubscribe from this topic, visit https://groups.google.com/d/
> topic/influxdb/NE1jUrAVLjo/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> influxdb+unsubscr...@googlegroups.com.
> To post to this group, send email to influxdb@googlegroups.com.
> Visit this group at https://groups.google.com/group/influxdb.
> To view this discussion on the web visit https://groups.google.com/d/
> msgid/influxdb/CALGqCvPk7MoF2rVFtU%2BKM8dVWsk5%3DSt9fG2i%3DG40%
> 3DW2LJSfVkQ%40mail.gmail.com
> 
> .
>
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Remember to include the version number!
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/CAFegRL_UipDqG27nTwADP3_g0e9fR_qdge5BP%2B10-GLMuEve%2BQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [influxdb] InfluxDB import

[Sean Beckett]

Please share the DDL from the top of the import file.

Dod you look in the logs? Are you sure you are querying the right database?

On Fri, Oct 14, 2016 at 3:45 AM,  wrote:

> How can i see the data imported in the database.
> I reached till this step -
>
> [root@integration@DEV influxdb]influx -import -path=first.txt
> 2016/10/14 09:22:45 Processed 3 commands
> 2016/10/14 09:22:45 Processed 6 inserts
> 2016/10/14 09:22:45 Failed 0 inserts
>
> Please help how i can see the measurements in the database.
> 'Show measurements' shows nothing.
>
> --
> Remember to include the version number!
> ---
> You received this message because you are subscribed to the Google Groups
> "InfluxData" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to influxdb+unsubscr...@googlegroups.com.
> To post to this group, send email to influxdb@googlegroups.com.
> Visit this group at https://groups.google.com/group/influxdb.
> To view this discussion on the web visit https://groups.google.com/d/
> msgid/influxdb/a3319963-4b54-49de-969e-72330af701af%40googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
Sean Beckett
Director of Support and Professional Services
InfluxDB

-- 
Remember to include the version number!
--- 
You received this message because you are subscribed to the Google Groups 
"InfluxData" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
Visit this group at https://groups.google.com/group/influxdb.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/influxdb/CALGqCvPk7MoF2rVFtU%2BKM8dVWsk5%3DSt9fG2i%3DG40%3DW2LJSfVkQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.